SQLÎÊÌâ - MS-SQL Server / »ù´¡Àà

Ë­ÄܸæËßÎÒ order by ºÍ group by µÄ¾ßÌåÓ÷¨ÒÔ¼°Çø±ð£¬ÖØÔÚÇø±ð£¬×îºÃ¸½ÉÏÒ»¸ö»òÕß¼¸¸öÀý×Ó...........
лл£¡

---

GROUP BY ÊÇ·Ö組£¬ÓÃ來¼Ó總計ËãµÈ²Ù×÷¡£
ORDER BY ¾ÍÊÇÅÅÁÐ順ÐòÓ㬷½±ã²Ù×÷Õ߲鿴數據¡£

---

ÒýÓÃ

SQL code
²éѯ֮order by£¬group byºÍhavingµÄʹÓà £¨×ª£©

£¨1£©order by

ORDER BY×Ó¾äµÄÓ﷨Ϊ£º

SELECT column1, SUM(column2) from "list-of-tables"

ORDER BY "column-list" [ASC | DESC];

[ ] = optional

ORDER¡­¡­

ѧϰ

---

SQL code:
²»ºÃ½âÊÍ£¬¿´Àý×Ó

create table tb (id int,counts int)

insert tb
select 1,10 union all
select 2,40 union all
select 3,30 union all
select 2,20


--ÔÚûÓÐorder byµÄÇé¿ö
select id,counts from tb
/*
id counts
----------- -----------
1 10
2 40
3 30
2 20

£¨ËùÓ°ÏìµÄÐÐÊýΪ 4 ÐУ©
*/
--ÓÐorder byµÄÇé¿ö 1£¬2£¬3 ÆäÖÐascÊÇÅÅÐò¹æÔòΪÉýÐò£¨´ÓСµ½´ó£©ÓÃdescÊÇ´Ó´óµ½Ð¡£¬Èç¹û²»Ð´Ä¬ÈÏΪasc
select id,counts from tb order by id asc
/*
id counts
----------- -----------
1 10
2 40
2 20
3 30

£¨ËùÓ°ÏìµÄÐÐÊýΪ 4 ÐУ©
*/
--ÏÈ°´idÅÅÐò£¬ÔÙ°´countsÅÅÐò
select id,counts from tb order by id asc,counts asc
/*
id