select cs_id,user_id, count(1)as sl,
ROW_NUMBER() OVER(ORDER BY cs_id asc, count(1) desc) as rownumber
from sys_customer_mx
where shenhe_state=1
group by cs_id,user_id
order by cs_id asc,sl desc
mysql添加ROW_NUMBER写法记录
最新推荐文章于 2023-04-19 16:17:08 发布