我需要分类排名既是:
a c
100 a
80 b
90 a
90 c
a b c
100 1 a
90 2 a
90 1 c
80 1 b
- select a , b = (select count(1) from tb where a = t.a and c >= t.c) , c
- from tb t order by a , t.c
我需要分类排名既是:
a c
100 a
80 b
90 a
90 c
a b c
100 1 a
90 2 a
90 1 c
80 1 b