SQLÖÐһЩ¼òµ¥µ«³£ÓõĶ«Î÷»ã×ÜÏÂ
In:µÈÖµÁ¬½Ó£¬ÓÃÀ´²éÕÒ¶à±íÏàͬ×ֶεļǼ
Not In:·ÇµÈÖµÁ¬½Ó£¬ÓÃÀ´²éÕÒ²»´æÔڵļǼ
Inner join:ÄÚÁ¬½Ó£¬Ö÷ÒªÓÃÀ´²éÕÒ¶¼·ûºÏÌõ¼þµÄ¼Ç¼
Left join:×óÁ¬½Ó£¬Ö÷ÒªÓÃÀ´²éÕÒ×ó±ßÓУ¬ÓÒ±ßûÓеÄÓÿÕÖµ±í´ï
Right join:ÓÒÁ¬½Ó£¬Ö÷ÒªÓÃÀ´²éÕÒÓÒ±ßÓУ¬×ó±ßûÓеÄÓÿÕÖµ±í´ï
Order By:ÉýÐò Asc ½µÐò Desc
Group By:·Ö×éÅÅÐò °´×ֶηÖ×é(Èç°´°à¼¶·Ö),ʹÓõĶ¼ÒªÓм¯ºÏº¯Êý´æÔÚ
Having :¶Ô·Ö×éÌõ¼þ½øÐÐÅжÏ,ʹÓö¼ÒªÈ·±£Ã¿¸ö×ֶζ¼ÒªÓü¯ºÏº¯Êý
COMPUTE BY£º×Ó¾äʹÄúµÃÒÔÓÃͬһ SELECT Óï¾ä¼È²é¿´Ã÷ϸÐУ¬Óֲ鿴»ã×ÜÐС£¿ÉÒÔ¼ÆËã×Ó×éµÄ»ã×ÜÖµ£¬Ò²¿ÉÒÔ¼ÆËãÕû¸ö½á¹û¼¯µÄ»ã×ÜÖµ¡£
ÐоۺϺ¯ÊýÃû³Æ£»ÀýÈ磬SUM¡¢AVG¡¢MIN¡¢MAX »ò COUNT
insert into:Ö÷Òª°Ñ²éѯµÄÓï¾ä²åÈëµ½ÐÂ±í¡£
inµÄÓ÷¨ÊÇwhere xx in ('aa','bb','cc')
Ï൱ÓÚ where xx='aa' or xx='bb' or xx='cc'
SQLÖÐINÓëEXISTSµÄÓ÷¨±È½Ï±¾ÎÄÕ¸üÐÂÓÚ£º07Äê10ÔÂ31ÈÕ À´Ô´£º±¾Õ¾ | ¹éÀࣺSQLServer
×÷Ϊ×Ó²éѯ:
IN£º
1¡¢SELECT * from family WHERE id IN (SELECT [id] from p_info)
·µ»Ø½á¹ûΪËùÓÐid°üº¬ÔÚp_info±íÖеÄPaples_Info½á¹û¼¯.
EXISTS£º
2¡¢SELECT * from family WHERE EXISTS (SELECT [id] from p_info)
·µ»Ø½á¹ûΪp_info´æÔÚÏàͬÊý¾ÝµÄfamily½á¹û¼¯.£¨²¢²»Ö¸¶¨ÄÄÁÐÏàͬ£©
3¡¢SELECT * from family WHERE EXISTS (SELECT [id] from p_info WHERE family.[id]=P_INFO.[id])
·µ»Ø½á¹ûͬ£¨1£©£¬ÕâÊÇÖ¸¶¨ÁËidÁйØÁªµÄ½á¹û¡£
×÷ΪÖ÷²éѯÌõ¼þ
IN £º
SELECT * from family WHERE id IN('12345','56789')
EXISTS£º
²ésqlÖÐasµÄÓ÷¨ËÑË÷µ½µÄһЩ¾µäµÄsqlÓï¾ä
¹Ø¼ü×Ö: SQL
×ܽáһЩ¹¤×÷ÖÐÓõ½»òÅöµ½µÄSQLÓï¾ä£¬Ï£ÍûÄÜÓë´ó¼Ò·ÖÏí£¬Í¬Ê±Ò²Ï£Íû´ó¼ÒÄÜÌṩ¸ü¶àµÄ¾«ÃîSQLÓï¾ä.....
1¡¢delete table1 from (select * from table2) as t2 where table1.id=t2.id
2¡¢truncate table table1 (²»ÔÚÊÂÎñÈÕÖ¾ÖÐ×ö¼Ç¼£¬±Èdelete table¿ì£¬µ«²»Äܼ¤»î´¥·¢Æ÷)
3¡¢update table1 set column=column+1 where id=(select id from table2)
4¡¢update table1 set column=column+1 from table1,table2 where table1.id=table2.id
5¡¢select top n [Percent] * from table1 'Êä³ö°Ù·Ö±È¼Ç¼
6¡¢select id,column1 * column2 as column from table1 '¿ÉËãÃ÷°×asµÄÓ÷¨ÁË
7¡¢select * from table1 where column1 like 'SQL#_G_O' escape '#' 'µ¥Æ¥Åä
8¡¢select table1.id from table1 wher
Ïà¹ØÎĵµ£º
//È¡³öÔ´Êý¾Ý
select groupname,totalnum,inputdate,groupid into #temp from
(select count(*)as totalnum,p.groupid,g.groupname,convert(nvarchar(10),inputdate,120) as 'inputdate'
from person p left join admin_group g on p.groupid = g.groupid and deleteflag = '0'
where p.inactive=' ......
1. SQLÓÅ»¯µÄÔÔòÊÇ£º
½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£
µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺
¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ
¼ì²é×Ó²éѯ ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½Óµ ......
Ñ¡Ôñ10gÊÇÒòΪ¶ÔÍø¸ñ¼¼Êõ±È½ÏºÃÆæ£¬ºÃÏñ»¹Ã»µÃµ½¹ã·ºÓ¦Óã¬Ò²¾ÍÎÞËùνÓëÇ°Ãæ°æ±¾ÓкܴóÇø±ðÁË¡£
ÔÚѸÀ×ÉÏÏÂÁ˸öÈí¼þ£¬ÔËÐÐsqlplusw£¬È»ºóÕÕ×ÅÊ飬¿ñÇÃÁËÒ»·£¬ÓÐÔÚÍøÉÏÏÂÁ˸öÊÓÆµ½Ì³Ì£¨MLDNħÀֿƼ¼_Oracle¿ÎÌã©£¬½²µÃͦºÃµÄ£¬¾ÍÊÇʱ¼ä³¤Á˵㣬²»Èç¿´ÊéÀ´µÃ¿ì¡£·´ÕýÏÖÔÚÖ»ÊÇÏëÊìϤһÏ»ù±¾Óï¾ä¡£
¿´ÁËÁ½ÌìÊéÁË¡£Á˽âÁËÒ» ......
´ÓÕâÒ»½Ú¿ªÊ¼ÄØ£¬ÎÒÃǾÍÒª¿ªÊ¼CLRµÄ±à³ÌÖ®ÂÃÁË¡£ÔÚÕâ֮ǰ£¬ÎÒÏȰѱ¾½ÚÖÐÐèÒªÁ˽âµÄÁ½¸öÐÂÀàSqlDataRecordºÍSqlMetaData£¬¼°Îå¸öз½·¨SqlContext.Pipe.SendResultsStart£¬SqlContext.Pipe.SendResultsRow£¬SqlContext.Pipe.SendResultsEnd£¬SqlContext.Pipe.SendºÍSqlContext.Pipe.ExecuteAndSend½øÐÐһϱØÒªµÄ˵Ã÷£¬·½±ã´ ......