sqlite 关于时间不连续分组查询前七条sql语句
SELECT * FROM Tab WHERE CreateTime>=(SELECT MIN(a) FROM (SELECT strftime('%Y-%m-%d',CreateTime) as a FROM Tab group by strftime('%Y-%m-%d',CreateTime) ORDER BY strftime('%Y-%m-%d',CreateTime) DESC LIMIT 7)) AND ProjectId = 'xxxx';
原创
2023-06-08 17:44:21 ·
197 阅读 ·
0 评论