A表:
a b c
------------------
a1 b1 1
a1 b2 2
a2 b3 3
a2 b4 4
a3 b5 5我想要的查询结果是,过滤 a 列的重复数据,并且按 c 列来排序a
----
a3
a2
a1请问该 怎么实现。
谢谢。
a b c
------------------
a1 b1 1
a1 b2 2
a2 b3 3
a2 b4 4
a3 b5 5我想要的查询结果是,过滤 a 列的重复数据,并且按 c 列来排序a
----
a3
a2
a1请问该 怎么实现。
谢谢。
from A表
order by a;
from A表
order by a desc
from A表
order by c;select distinct a
from A表
order by c desc;
a b c
------------------
a1 b1 1
a2 b3 2
a2 b4 2
a3 b5 3
a1 b2 4
select t.a from (select a,max(c)as c from tbl group by a) t order by t.c desc;
如果按a对应的最小的c来排:
select t.a from (select a,min(c)as c from tbl group by a) t order by t.c desc;
抱歉select a from(
select a,max(c) c
from A表
group by a)
order by c;select a from(
select a,max(c) c
from A表
group by a)
order by c desc;