SQL SERVER数据库多having 用法
举实例：查询大于500的数据，并按时间进行汇总排序
select CONVERT(VARCHAR(10),DGH,23),COUNT(*) from yxhis2017..VTBMZGHMX2017 where bth=0 GROUP BY CONVERT(VARCHAR(10),DGH,23) HAVING COUNT(*)>500 ORDER BY CONVERT(VARCHAR(10),DGH,23)
举实例：查询大于500的数据，并按时间进行汇总排序
select CONVERT(VARCHAR(10),DGH,23),COUNT(*) from yxhis2017..VTBMZGHMX2017 where bth=0 GROUP BY CONVERT(VARCHAR(10),DGH,23) HAVING COUNT(*)>500 ORDER BY CONVERT(VARCHAR(10),DGH,23)
