例如:查询挂号超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)
since-1995 2019-04-30 17:21 原文
例如:查询挂号超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)