在多列中去掉某一列中重复的值(sql 语句)
在一个表中c列有重复值,a为主键,如何select a,b列同时排除c列有重复的?
SELECT a,c,b FROM table WHERE a IN (SELECT MIN(a) AS a FROM table GROUP BY c )
在一个表中c列有重复值,a为主键,如何select a,b列同时排除c列有重复的?
SELECT a,c,b FROM table WHERE a IN (SELECT MIN(a) AS a FROM table GROUP BY c )