1、查询结果集
2、结果集与r表连表查询,查询出rank排名
3、注意:排序写在外面,写在结果集中不生效
SELECT a.*, (@r:=@r+1) as rank
FROM (select * from chat_record
WHERE chat_id = '1735114524751757314' ) a,(select @r:=0) r order by time desc
1、查询结果集
2、结果集与r表连表查询,查询出rank排名
3、注意:排序写在外面,写在结果集中不生效
SELECT a.*, (@r:=@r+1) as rank
FROM (select * from chat_record
WHERE chat_id = '1735114524751757314' ) a,(select @r:=0) r order by time desc