字段1 字段2 字段3 1 a A 2 a B 3 b V 4 b F 5 c O 6 d G 类似上边的表,现在想去重查询出字段2所有值,然后按字段1排序,应该怎么写sql语句? 结果出来应该是: a b c d
1)
select * from (select max(字段1) as 字段1,字段2 from 表 group by 字段2)t order by 字段12)SELECT A.* FROM 表 A JOIN ( SELECT MIN(字段1) AS 字段1,字段2 FROM 表 GROUP BY 字段2 ) B ON (A.字段1=B.字段1 AND A.字段2=B.字段2) ORDER BY A.字段1