当前标签: group by

Oracle 数据库中的GROUP BY与HAVING

SELECT name,count(id) from user GROUP BY name HAVING count(id)>1
2018-12-11 16:17 阅读(449)
©2016-2019 MaTools All rights reserved, 粤ICP备17059708号, IP流:
106.***.159.45 34.***.203.209 46.***.248.135 53.***.143.107 36.***.215.129 83.***.254.190 54.***.2.210 51.***.61.251 81.***.174.241 21.***.92.192