sqlite 查询一条重复数据

前端之家收集整理的这篇文章主要介绍了sqlite 查询一条重复数据前端之家小编觉得挺不错的,现在分享给大家,也给大家做个参考。
  1. SELECT Attendance_Time as 时间,PicPath AS 图片
  2. FROM [main].[UserRecord]
  3. WHERE ([UserRecord].PicPath) IN (
  4. SELECT PicPath
  5. FROM [main].[UserRecord]
  6. GROUP BY PicPath
  7. HAVING count( * ) >= 2
  8. ORDER BY PicPath
  9. );

猜你在找的Sqlite相关文章