oracle表达式之“ora-0079”不是group by表达式分析（未完待续。。。）

with tab as
 (select t.object_pid,
         t.mesh,
         round(x, 8) x,
         round(y, 8) y,
         round(z, 3) z,
         id
    from had_object_box_pole t, table(sdo_util.GetVertices(t.geometry)) g),
tab1 as
 (select t.object_pid,
         t.mesh,
         t.x,
         t.y,
         t.z,
         t.id,
         count(*) over(partition by t.object_pid, t.x, t.y, t.z) num,
         row_number() over(partition by t.object_pid, t.x, t.y, t.z order by t.id) sq
    from tab t
   where t.id > 1),
tab2 as
 (select t.object_pid,
         t.mesh,
         t.x,
         t.y,
         t.z,
         t.id,
         t.num,
         t.sq,
         (t.x || ',' || t.y || ',' || t.z) str
    from tab1 t
   where num > 1),
tab3 as
 (select object_pid,
         t.id,
         mesh,
        substr(sys_connect_by_path(str,'|'),2) strVal,
         wm_concat(t.id) strid
    from tab2 t
   where connect_by_isleaf = 1
   start with sq = 1
  connect by sq = PRIOR sq + 1
         and object_pid = PRIOR object_pid
         and sq < =(select max(sq) from tab2)
 group by object_pid,t.id,mesh)select * from tab3 t3