当前标签: group by

Oracle 数据库中的GROUP BY与HAVING

SELECT name,count(id) from user GROUP BY name HAVING count(id)>1
2018-12-11 16:17 阅读(504)
©2016-2019 MaTools All rights reserved, 粤ICP备17059708号, IP流:
110.***.28.233 90.***.26.47 75.***.101.99 12.***.165.146 79.***.147.31 29.***.78.104 102.***.175.134 24.***.228.215 63.***.154.9 100.***.11.138