distinct 多字段去重复 ╰半橙微兮° 2022-09-19 10:38 119阅读 0赞 distinct 后面只能跟一个去重复的条件,那结果想以一个字段去重复查多个字段怎么办呢 select id,admin\_id from feature\_and\_admin a group by a.admin\_ID select \*,count(distinct a.admin\_ID) from feature\_and\_admin a group by a.admin\_ID select \* from feature\_and\_admin a where a.id in(select max(id) from feature\_and\_admin group by admin\_id) select id,min(a.admin\_ID) from feature\_and\_admin a group by a.admin\_ID s
还没有评论,来说两句吧...