oracle 给分组加序号

做报表需要给各车间的数据显示到一起，每行显示三个车间的数据，按照分组的序号换行显示

DENSE_RANK() OVER(ORDER BY b.dept_name) grp

 

--整段

select * from (
select m.jxcdl,
              DENSE_RANK() OVER(ORDER BY b.dept_name) grp,
               b.dept_name as shopname,
               c.dept_name as teamname,
               t.*
          from hm_machine_asset t
          left join (select a.model_id,
                           t.data_text   as device_class,
                           a.equip_model,
                           a.remark      as jxcdl
                      from hm_train_model a
                      left join mf_dict_data t
                        on a.device_class = t.data_value
                     where t.dict_id = 'hm.asset.type') m
            on t.device_class = m.model_id
          left join mf_department b
            on b.dept_id = t.assigned_shop
          left join mf_department c
            on c.dept_id = t.assigned_team
         where t.rescue_equip_state = '0'
           and t.assigned_team is not null
           and t.asset_type = '0' ) m
 order by shopname, teamname,jxcdl