mysql 分组之后再排序

AGMS

于 2023-08-16 10:19:50 发布

阅读量91

点赞数

文章标签： mysql sql 数据库

本文链接：https://blog.csdn.net/weixin_43966864/article/details/132313719

版权

select
t.hosp_id,
t.hosp_area_id,
t.out_in_flag,
t.critical_type,
t.send_minute,
(@row_number := if(@current_group = CONCAT(t.hosp_id, t.hosp_area_id, t.out_in_flag, t.critical_type),
@row_number + 1,
1)) as order_no,
(@current_group := CONCAT(t.hosp_id, t.hosp_area_id, t.out_in_flag, t.critical_type)) group_no
from
(
select
hosp_id,
hosp_area_id,
out_in_flag,
critical_type,
send_minute
from
dvcvms.critical_send_roles
order by
hosp_id,
hosp_area_id,
out_in_flag,
critical_type,
send_minute) as t
cross join (
select
@row_number := 0,
@current_group := ‘’) as r