第二大的
select * from t a where (select count(*) from where 字段>a.字段)=1
第三大的
select * from t a where (select count(*) from where 字段>a.字段)=2
select * from t a where (select count(*) from where 字段>a.字段)=1
第三大的
select * from t a where (select count(*) from where 字段>a.字段)=2
select * from t a where (select count(*) from where 字段>a.字段)=n
第二大的
select * from t a where (select count(distinct(字段)) from where 字段>a.字段)=1
第三大的
select * from t a where (select count(distinct(字段)) from where 字段>a.字段)=2
select * from t a where (select count(distinct(字段)) from where 字段>a.字段)=n