SQL·ÖÒ³²éѯ
·ÖÒ³sql²éѯÔÚ±à³ÌµÄÓ¦Óúܶ࣬Ö÷ÒªÓд洢¹ý³Ì·ÖÒ³ºÍsql·ÖÒ³Á½ÖÖ£¬ÎұȽÏϲ»¶ÓÃsql·ÖÒ³£¬Ö÷ÒªÊǺܷ½±ã¡£ÎªÁËÌá¸ß²éѯЧÂÊ£¬Ó¦ÔÚÅÅÐò×Ö¶ÎÉϼÓË÷Òý¡£sql·ÖÒ³²éѯµÄÔÀíºÜ¼òµ¥£¬±ÈÈçÄãÒª²é100ÌõÊý¾ÝÖеÄ30-40Ìõ£¬ÄãÏȲéѯ³öÇ°40Ìõ£¬ÔÙ°ÑÕâ30Ìõµ¹Ðò£¬ÔÙ²é³öÕâµ¹ÐòºóµÄÇ°Ê®Ìõ£¬×îºó°ÑÕâÊ®Ìõµ¹Ðò¾ÍÊÇÄãÏëÒªµÄ½á¹û¡£
ÏÂÃæ°Ñsql·ÖÒ³²éѯµÄÔÀíÓÃsqlÓï¾ä±íÏÖһϣº
-- ·ÖÒ³ ÉýÐò£¨ËѳöµÄ½á¹ûÔÙµ¹Ðò£©
SELECT TOP 10 * from (SELECT TOP 40 * from A01 ORDER BY A00 ASC) AS T ORDER BY A00 DESC
-- ·ÖÒ³ ÉýÐò
SELECT * from (SELECT TOP 10 * from (SELECT TOP 40 * from A01 ORDER BY A00 ASC) AS T ORDER BY A00 DESC) AS T1 ORDER BY A00 ASC
-- ·ÖÒ³ ½µÐò£¨ËѳöµÄ½á¹ûÔÙµ¹Ðò£©
SELECT TOP 10 * from (SELECT TOP 40 * from A01 ORDER BY A00 DESC) AS T ORDER BY A00 ASC
Ïà¹ØÎĵµ£º
order by
ÅÅÐòͨ¹ýorder by×Ó¾äʵÏÖ£¬order byÔÚSELECTÓï¾äµÄ×îºó¡£
Óï·¨£º
order by field1 [ASC|DESC][,field2 [ASC|DESC],..,fieldn [ASC|DESC]]
ASC£ºÉýÐò
DESC£º½µÐò
ĬÈÏΪÉýÐò
¿ÕÖµ×÷ΪÎÞÇî´óÀ´´¦Àí¡£
ÁíÍâ¿ÉÒÔ°´ÕÕ²éѯÁбíÖÐÐòºÅ½øÐÐÅÅÐò¡£
ϵͳÔÚÓû§Ð´³ö²éѯÁбíµÄͬʱ¾Í¸³Óèÿ¸öÁÐÃûÒ»¸ ......
//°´×ÔÈ»ÖÜͳ¼Æ
select to_char(date,'iw'),sum()
from
where
group by to_char(date,'iw')
//°´×ÔÈ»ÔÂͳ¼Æ
select to_char(date,'mm'),sum()
from
where
group by to_char(date,'mm')
//°´¼¾Í³¼Æ
select to_char(date,'q'),sum()
fr ......
Ò»°ãʹÓÃSQL ServerµÄ¼¯³ÉÈÏ֤ʱ£¬¶¼ÐèÒªµÇ½½øÓò£¬ÏÂÃæ½éÉÜÒ»ÖÖ²»ÐèÒªµÇ½Óò¾Í¿ÉÒÔʹÓÃÓòÓû§µÇ½SQL ServerµÄ·½·¨¡£
SQL Server Management Studio 2005ºÍ2008µÄ¿ì½Ý·½Ê½ÈçÏÂͼ£º
SQL Server 2008 x64: "C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"
SQL ......
1. ¶¨ÒåÓα궨Òå
ÓαêÓï¾äµÄºËÐÄÊǶ¨ÒåÁËÒ»¸öÓαê±êʶÃû£¬²¢°ÑÓαê±êʶÃûºÍÒ»¸ö²éѯÓï¾ä¹ØÁªÆðÀ´¡£DECLAREÓï¾äÓÃÓÚÉùÃ÷Óα꣬Ëüͨ¹ýSELECT²éѯ¶¨ÒåÓαê´æ´¢µÄÊý¾Ý¼¯ºÏ¡£Óï¾ä¸ñʽΪ£º
DECLARE ÓαêÃû³Æ [INSENSITIVE] [SCROLL]
CURSOR FOR selectÓï¾ä
[FOR{READ ONLY|UPDATE[OF ÁÐÃû×Ö±í]}]
²ÎÊý˵Ã÷£º
INSENSITIVEÑ¡Ï ......
ÔÎÄת×Ô:http://tech.it168.com/a2009/0218/265/000000265868.shtml
Ë÷ÒýÊÇÒÔ±íÁÐΪ»ù´¡µÄÊý¾Ý¿â¶ÔÏó¡£Ë÷ÒýÖб£´æ×űíÖÐÅÅÐòµÄË÷ÒýÁУ¬²¢ÇҼͼÁËË÷ÒýÁÐÔÚÊý¾Ý¿â±íÖеÄÎïÀí´æ´¢Î»Öã¬ÊµÏÖÁ˱íÖÐÊý¾ÝµÄÂß¼ÅÅÐò¡£Í¨¹ýË÷Òý£¬¿ÉÒÔ¼Ó¿ìÊý¾ÝµÄ²éѯËٶȺͼõÉÙϵͳµÄÏìӦʱ¼ä;¿ÉÒÔʹ±íºÍ±íÖ®¼äµÄÁ¬½ÓËٶȼӿ졣
µ«ÊÇ£¬ ......