如何在ORDER BY子句中使用组函数？
我们可以使用ORDERBY子句中的组函数对结果集组进行排序。默认情况下，排序顺序是递增的，但是我们可以使用DESC关键字将其反转。
示例
mysql> Select designation, YEAR(Doj), count(*) from employees GROUP BY designation, YEAR(DoJ) ORDER BY Count(*) DESC; +-------------+-----------+----------+ | designation | YEAR(Doj) | count(*) | +-------------+-----------+----------+ | Prof | 2009 | 2 | | Asst.Prof | 2015 | 1 | | Asst.Prof | 2016 | 1 | | Prof | 2010 | 1 | | Asso.Prof | 2013 | 1 | +-------------+-----------+----------+ 5 rows in set (0.00 sec) mysql> Select designation, YEAR(Doj), count(*) from employees GROUP BY designation, YEAR(DoJ) ORDER BY designation DESC; +-------------+-----------+----------+ | designation | YEAR(Doj) | count(*) | +-------------+-----------+----------+ | Prof | 2009 | 2 | | Prof | 2010 | 1 | | Asst.Prof | 2015 | 1 | | Asst.Prof | 2016 | 1 | | Asso.Prof | 2013 | 1 | +-------------+-----------+----------+ 5 rows in set (0.00 sec)
热门推荐
10 姐妹订婚刺绣祝福语简短
11 牛年的吉祥祝福语简短
12 孩子满月红包祝福语简短
13 业主装修完成祝福语简短
14 小学同学简短祝福语
15 新郎致辞诗句祝福语简短
16 书法朋友祝福语简短精辟
17 祝福语大全短句简短英语
18 新年祝福语大全简短感谢