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 查询一条重复数据
最新推荐文章于 2022-10-07 08:17:13 发布