排序后查重

SELECT DISTINCT ON(MID) * from draft where status='pass_' and mid in ('2197107','2235859','2122564') and is_delete is FALSE and is_online is TRUE ORDER BY mid,created_at DESC

posted @ 2020-07-16 20:49  import*  阅读(151)  评论(0编辑  收藏  举报