mysql查询数据生成排序序号
有时因为业务的需求，我们需要在查询出的数据中加上排序序号，例：SQL：select a.*, (@i:= @i+1) as rank_no from performance a,(select @i:=0) b ;或者这样SQL：select a.*, (@i:= @i+1) as rank_no from (select * from performance ORDER BY time desc
·
有时因为业务的需求，我们需要在查询出的数据中加上排序序号，例：
SQL：select a.*, (@i:= @i+1) as rank_no from performance a,(select @i:=0) b ;
或者这样
SQL：select a.*, (@i:= @i+1) as rank_no from (select * from performance ORDER BY time desc) a,(select @i:=0) b;
(select @i:=0) b：每次查询时都会重新排序；如果想要每次查询有累加的效果，可以去掉
SQL：select a.*, (@i:= @i+1) as rank_no from (select * from performance ORDER BY time desc) a
SQL语句就自行发挥吧！
为开发者提供学习成长、分享交流、生态实践、资源工具等服务，帮助开发者快速成长。
更多推荐
5
0- 0
已为社区贡献1条内容
所有评论(0)