-- 这个是基于分组生成序号
SET @rank:=0;
SELECT * FROM
(SELECT a.*,
IF(@tmp=bill_code,@rank:=@rank + 1,@rank:=1) AS group_id,
@tmp:=bill_code AS tmp
FROM
(
SELECT id,bill_code,order_no
FROM rp_vehicle_repair_fault
where
(
bill_code like '%X'
or bill_code like '%D'
)
and LENGTH(order_no)=LENGTH('2147483647')
and data_status='0'
)
a ORDER BY bill_code DESC) b
WHERE b.group_id<=110000
MYSQL基于指定字段分组生成序号
最新推荐文章于 2024-07-17 07:12:01 发布