sqlite 查询一条重复数据，sqlite查询一条重复

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
       );