1. 示例
SELECT COUNT(nRoomUseId),nRoomUseId FROM `TbCourse` GROUP BY nRoomUseId HAVING COUNT(nRoomUseId) > 1
查询示例.png
SELECT COUNT(nRoomUseId),nRoomUseId FROM `TbCourse` GROUP BY nRoomUseId HAVING COUNT(nRoomUseId) > 1
查询示例.png
本文标题:SQL 查询单表之中大于2条的数据
本文链接:https://www.haomeiwen.com/subject/ppvnortx.html
网友评论