sqlite 查询一条重复数据

前端之家收集整理的这篇文章主要介绍了sqlite 查询一条重复数据前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
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
       );

猜你在找的Sqlite相关文章