我的github

select distinct * from

参考:https://blog.csdn.net/qq_35091353/article/details/127805844

参考2:https://blog.csdn.net/qq_36761831/article/details/82857545

查找重复的数据

SELECT *
FROM t_info a
WHERE ((SELECT COUNT(*)
FROM t_info
WHERE Title = a.Title) > 1)
ORDER BY Title DESC

参考3:https://www.jb51.net/database/285988i9z.htm

posted on 2024-01-04 09:37  XiaoNiuFeiTian  阅读(3)  评论(0编辑  收藏  举报