Çë½ÌÒ»¸ö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
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
±íÊý¾Ý
COL1 COL2 COL2 COL4 COL5
----------------------------------------------------------------------------------------------
2010-05-05 00:00 ......
¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿
¸÷ÊãÆð¼û
Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö
¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË
¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã
Â¥Ö÷Çë²ÎÔÄ
http://msdn.micr ......