sql_查询表中的重复数据
程序员文章站
2022-04-14 16:43:22
...
select * from SphereYuan
SELECT TaskId,COUNT(0) AS cfsj FROM SphereYuan GROUP BY TaskId HAVING COUNT(TaskId) > 0结果如图：