查询数据排名情况SQL

1/准备测试数据 ———————————————————————————create table t1(c1 integer,c2 integer,c3 integer); insert into t1 values(1,2,3) insert into t1 values(1,8,4)insert into t1 values(1,4,4) insert into t1 values(1,4,5) insert into t1 values(1,5,5) insert into t1 values(2,2,3) insert into t1 values(2,8,4)insert into