為此，您可以將GROUP BY與ORDER BY子句一起使用。讓我們首先創建一個表-create?table?DemoTable1499

->?(

->?StudentName?varchar(20),

->?StudentMarks?int

->?);

使用插入命令在表中插入一些記錄-insert?into?DemoTable1499?values('Chris',56);

insert?into?DemoTable1499?values('David',78);

insert?into?DemoTable1499?values('Bob',98);

insert?into?DemoTable1499?values('Chris',45);

insert?into?DemoTable1499?values('David',98);

insert?into?DemoTable1499?values('Bob',58);

使用select語句顯示表中的所有記錄-Mysql>?select?*?from?DemoTable1499;

這將產生以下輸出-+-------------+--------------+

|?StudentName?|?StudentMarks?|

+-------------+--------------+

|?Chris???????|???????????56?|

|?David???????|???????????78?|

|?Bob?????????|???????????98?|

|?Chris???????|???????????45?|

|?David???????|???????????98?|

|?Bob?????????|???????????58?|

+-------------+--------------+

6?rows?in?set?(0.00?sec)

以下是匯總行值并對結果進行排序的查詢-select?StudentName,sum(StudentMarks)?as?TotalSum?from?DemoTable1499

->?group?by?StudentName

->?order?by?TotalSum?desc;

這將產生以下輸出-+-------------+----------+

|?StudentName?|?TotalSum?|

+-------------+----------+

|?David???????|??????176?|

|?Bob?????????|??????156?|

|?Chris???????|??????101?|

+-------------+----------+

3?rows?in?set?(0.00?sec)

總結

以上是生活随笔為你收集整理的mysql 汇总行_MySQL查询汇总行的值并对结果进行排序？的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。