当前位置: 代码迷 >> SQL >> 联接sql
  详细解决方案

联接sql

热度:49   发布时间:2016-05-05 14:48:20.0
连接sql
select substr(sys_connect_by_path(v_param_name, ','), 2) a, a.*
  from (select aa.*,
               v_item_id || ',' || (rno + 1) rno1,
               v_item_id || ',' || rno rno2
          from (select v_item_id,
                       v_param_name,
                       row_number() over(partition by v_item_id order by n_param_id) rno,
                       row_number() over(partition by v_item_id order by n_param_id desc) flag
                  from tb_pu_parameter) aa) a
where flag = 1
connect by prior rno1 = rno2
start with rno = 1

  相关解决方案