例如:查询挂号超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)
SQL SERVER数据库多条件查询
最新推荐文章于 2024-01-17 12:03:25 发布
例如:查询挂号超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)