12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
ADADADADAD
建站问答 时间：2024-12-01 19:16:39
作者：文/会员上传
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
12-09
mysql中为排序添加排序名的方法语法：SELECT (@rownum:= @rownum+1) AS rank FROM (SELECT * FROM （自己的表名）) a,(SELECT @rownum:=0) b使用方法：SELECT a.userId,a.userName,
以下为本文的正文内容，内容仅供参考！本站为公益性网站，复制本文以及下载DOC文档全部免费。
语法：
SELECT (@rownum:= @rownum+1) AS rank FROM (
SELECT * FROM （自己的表名）
) a,(SELECT @rownum:=0) b
使用方法：
SELECT a.userId,a.userName,a.sumInterval, a.tomatoNumber, @rownum := @rownum + 1 as rank
FROM (
SELECT
user_id AS userId,
user_name AS userName,
sum( tomato_time_interval ) AS sumInterval,
COUNT( user_id ) AS tomatoNumber
FROM
`tm_record_s`
WHERE
state = '1'
AND tomato_time_interval >= 1500
AND tomato_date = '2019-04-26'
GROUP BY
user_id
ORDER BY
COUNT( user_id ) DESC
) a, (SELECT @rownum :=0) b
11-20
11-19
11-20
11-20
11-20
11-19
11-20
11-20
11-19
11-20
11-19
11-19
11-19
11-19
11-19
11-19