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