日期:2014-05-17 浏览次数:20975 次
select a.id, a.c1, b.c2 from (select id, max(c1) c1 from (select id, wm_concat(col) over(partition by id order by col) c1 from (select id, col from t1 order by id, col)) group by id) a, (select id, max(c2) c2 from (select id, wm_concat(col) over(partition by id order by col) c2 from (select id, col from t2 order by id, col)) group by id) b where a.id = b.id and c1 <> c2;