17,377
社区成员
发帖
与我相关
我的任务
分享
case when stock_num<4 and succ_rate >=70 then 2
when stock_num<4 and succ_rate >=60 then 3
when stock_num<4 and succ_rate >=50 then 4
when stock_num<4 and succ_rate >=40 then 5
when stock_num<4 and succ_rate >=30 then 6
when stock_num<4 and succ_rate <30 then 7
when stock_num>4 and succ_rate >=70 then 1
when stock_num>4 and succ_rate >=60 then 2
when stock_num>4 and succ_rate >=50 then 3
when stock_num>4 and succ_rate >=40 then 4
when stock_num>4 and succ_rate >=30 then 5
when stock_num>4 and succ_rate >=20 then 6
when stock_num>4 and succ_rate <20 then 7
end as suc_level
--不知道你要的是什么样的结果
select 用户,收益,推荐数,成功率,rownum 排名
from tb
order by 成功率,收益 desc
select * from
(select * from table order by 成功率 desc,收益 desc)
where rownum<5;