select a.a,b.b, MAX(a.a1 )KEEP (DENSE_RANK LAST ORDER BY a.a1), MAX(a.a2 )KEEP (DENSE_RANK LAST ORDER BY a.a1), MAX(a.a3 )KEEP (DENSE_RANK LAST ORDER BY a.a1), MAX(b.b1 )KEEP (DENSE_RANK LAST ORDER BY a.a1), MAX(b.b2 )KEEP (DENSE_RANK LAST ORDER BY a.a1), MAX(b.b3 )KEEP (DENSE_RANK LAST ORDER BY a.a1), from a,b where a.id=b.id group a.a,b.b;
from test
group by test.………
MAX(a.a1 )KEEP (DENSE_RANK LAST ORDER BY a.a1),
MAX(a.a2 )KEEP (DENSE_RANK LAST ORDER BY a.a1),
MAX(a.a3 )KEEP (DENSE_RANK LAST ORDER BY a.a1),
MAX(b.b1 )KEEP (DENSE_RANK LAST ORDER BY a.a1),
MAX(b.b2 )KEEP (DENSE_RANK LAST ORDER BY a.a1),
MAX(b.b3 )KEEP (DENSE_RANK LAST ORDER BY a.a1),
from a,b
where a.id=b.id
group a.a,b.b;