SQL 查询单表之中大于2条的数据

2022-09-22 本文已影响0人 Rinaloving

SELECT COUNT(nRoomUseId),nRoomUseId  FROM `TbCourse`    GROUP BY nRoomUseId  HAVING COUNT(nRoomUseId)  > 1

查询示例.png