select max(decode(a.c1,'a','a',null)),max(decode(a.c1,'a',c2)),max(decode(a.c1,'a',c3)),
max(decode(a.c1,'b','b',null)),max(decode(a.c1,'b',c2)),max(decode(a.c1,'b',c3)),
max(decode(a.c1,'c','c',null)),max(decode(a.c1,'c',c2)),max(decode(a.c1,'c',c3)) from test_te a group by c4
max(decode(a.c1,'b','b',null)),max(decode(a.c1,'b',c2)),max(decode(a.c1,'b',c3)),
max(decode(a.c1,'c','c',null)),max(decode(a.c1,'c',c2)),max(decode(a.c1,'c',c3)) from test_te a group by c4
当然也可能缺的是B 高手们来吧
A 11 10 1
B 12 12 1
C 22 23 1
D 22 23 1
A 44 44 2
B 45 45 2
C 46 46 2
有什么好的方法得到以下的结果(C4是用来分组的,1为一组,2为一组)
1 2 3 4 5 6 7 8 9 10 11
----------------------------------
A 11 10 B 12 12 C 22 23 22 23
A 44 44 B 45 45 C 46 46 0 0顺便UP