sqlite 查询一条重复数据

来源:互联网 发布:阿里云服务器瘫痪 编辑:程序博客网 时间:2024/05/06 19:15
SELECT Attendance_Time as 时间, PicPath AS 图片  FROM [main].[UserRecord] WHERE ([UserRecord].PicPath) IN (           SELECT PicPath             FROM [main].[UserRecord]            GROUP BY PicPath           HAVING count( * ) >= 2            ORDER BY PicPath       );

0 0
原创粉丝点击