SELECT DISTINCT(id) FROM test1 WHERE date = '2016-10-16 00:00:00' AND id IN ( SELECT id FROM test1 GROUP BY id HAVING min(date) < '2016-10-16 00:00:00' ) ORDER BY id
点赞 评论

相关推荐

牛客网
牛客网在线编程
牛客网题解
牛客企业服务