mysql实现row_number() 功能
SELECT> FROM(SELECT@row_number := CASE WHEN@customer_no = group_idTHEN@row_number + 1ELSE1 END ASnum /*如果同group_id那么排名加1,否则更新为1*/
,@customer_no := group_idASgroup_id /*重新加载group_id*/
,id , sort_id /*原有数据*/
FROMtest,( SELECT@customer_no := 0,@row_number := 0)ASt
ORDER BY group_id ,sort_id DESC ,id)a
WHERE num
页:
[1]