如何在Sql中一起使用Group by和Order by？ [英] How to use Group by and Order by together in Sql?

问题描述

如何在Sql中一起使用Group by和Order by？

解决方案

像这样：

  SELECT 用户名，COUNT（帖子）
  FROM  MyTable 
  GROUP   BY 用户名
  ORDER   BY  COUNT（帖子）

嗨..

  SELECT  value1，value2，COUNT（value1） AS  val 
  FROM  table_name  GROUP  按 value1，value2 
  HAVING  val>  0   ORDER   BY  value2  DESC  

只有Groupby

  SELECT 年，SUM（利润） FROM 销售 GROUP   BY 年; 

谢谢你

< pre lang =sql> group by id

订单 按名称 desc

How to use Group by and Order by together in Sql?

解决方案

Like this:

SELECT Username, COUNT(Posts)
FROM MyTable
GROUP BY Username
ORDER BY COUNT(Posts)

Hi..

SELECT value1, value2, COUNT(value1) AS val
FROM table_name GROUP by value1 , value2
HAVING val > 0 ORDER BY value2 DESC

Only Groupby

SELECT year, SUM(profit) FROM sales GROUP BY year;

Thank u

group by id
 
order by name desc

这篇关于如何在Sql中一起使用Group by和Order by？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！