Çë½ÌÒ»¸ösql²éѯµÄÎÊÌâ¡£ - MS-SQL Server / Ó¦ÓÃʵÀý
ÓÐÁ½±í£¨T_CAR£©
{
CAR_ID INT IDENTITY
CUST_ID INT
}
(T_CUSTOMER)
{
CUST_ID INT IDENTITY
CUST_NAME VARCHAR(100)
}
ÏÖÔÚÒª²éѯ±í£¨T_CAR£©ÖÐ×Ö¶ÎCUST_ID²»´æÔÚ±í£¨T_CUSTOMER£©µÄÊý¾Ý
ÒÑÖª²éѯsqlÓÐÁ½¸ö
Ò»£©
SELECT * from T_CAR WHERE CUST_ID NOT IN (SELECT CUST_ID from T_CUSTOMER)
¶þ£©
SELECT * from T_CAR C LEFT JOIN T_CUSTOMER R ON C.CUST_ID=R.CUST_ID WHERE R.CUST_ID IS NULL (ÒÑÖªCUST_IDÔÚ±íT_CARÊÇΨһµÄ¡£)
ÇëÎÊ¡£ÒÔÉÏÁ½ÖÖ²éѯsql£¬ÐÔÄܸüºÃ(ÔÚÈçÏÂÈýÖÖÇé¿öÏ£º1>±íT_CUSTOMERµÄÊý¾ÝÁ¿ºÜ´ó£¬2>±íT_CARµÄÊý¾ÝÁ¿ºÜ´ó£¬ 3>Á½±íµÄÊý¾ÝÁ¿¶¼ºÜ´ó)£¿
ÉÏÃæÁ½¸öÏà±È£¬µÚ¶þ¸ö²éѯЧÂÊ»á¸ß
ѧϰ¡£
select *
from car
left join customer c on car.cust_id=c.cust_id
where c.cust_id is null
Ïà¹ØÎÊ´ð£º
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡
Ëæ±ã¸ãÒ»D°æ°É£¬
ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù
http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
C=ID T="INTEGER" P=No M=No N="񅧏" Z=false,
C=Ques ......
ÎÒÓÐÒ»¸ö×Ö¶ÎÊÇ varchar(1) ÀàÐÍ£¬¶þ½øÖƱíʾҲ¾ÍÊÇ8λµÄ ¡®0000 0000¡¯
±ÈÈçÕâ¸öʱºòÎÒÐèҪɸѡ³öÕâ¸ö×Ö¶ÎΪËùÓÐµÄ ¡®0000 0100¡¯µÄÐУ¬ÇëÎÊSQLÄÜʵÏÖÕâÑùµÄ¡°Î»¡±µÄɸѡÂð£¿
лл~~~
ÓÐλ²Ù×ݺ¯ÊýÂ𣿲»ÐоÍ× ......