当前标签: group by

Oracle 数据库中的GROUP BY与HAVING

SELECT name,count(id) from user GROUP BY name HAVING count(id)>1
2018-12-11 16:17 阅读(465)
©2016-2019 MaTools All rights reserved, 粤ICP备17059708号, IP流:
124.***.230.209 39.***.241.178 67.***.30.253 41.***.144.227 82.***.195.176 40.***.223.32 25.***.251.171 79.***.142.5 49.***.8.139 117.***.29.179