MySql没有像Oracle中有RowNum, 可以用来排序, 但是可以根据sql语句的执行先后顺序来实现类似的效果。
select @rownum:=@rownum+1 as rownum, t1.liege_name, t1.rank_id, t3.kill_num from b_info_liege t1, (select sum(kill_num) kill_num, liege_id from f_liege_monster group by liege_id) t3, (SELECT @rownum:=0) r where t1.id = t3.liege_id order by t3.kill_num desc;
sql的执行先后顺序:
1: 先执行子查询select sum(kill_num) kill_num, id from f_liege_monster group by id;
2:然后根据kill_num来做排序;
3:最后在查询需要的字段;
这里的rounum就会根据排序后的先后顺序来递增;
MySql实现rownum的sql语句
最新推荐文章于 2024-07-28 16:57:04 发布