查询所有数据排名
SELECT a.yhid,a.zjf,a.dqjf,(@rowno:=@rowno+1) as rowno FROM jfxt_yhjfxx a,(select (@rowno:=0)) b ORDER BY a.zjf DESC
指定查询某条数据的排名
SELECT * FROM ( SELECT a.yhid,a.zjf,a.dqjf,(@rowno:=@rowno+1) as rowno FROM jfxt_yhjfxx a,(select (@rowno:=0)) b ORDER BY a.zjf DESC) c WHERE c.yhid='f531aded-bd09-4574-8826-4482bd918f91'
如对本文有疑问, 点击进行留言回复!!
MySQL-关系代数-并、交、差、等值连接、自然连接、左连接。。。
【MySQL牛客】10.获取所有非manager的员工emp_no
网友评论