J Jj1985 Unregistered / Unconfirmed GUEST, unregistred user! 2009-10-21 #1 有一表A 结构如下.a b c1 I 11 am 21 JJ 32 How 12 are 22 you 3 要得出结果没 a b 1 I am JJ 2 How Are you
I iceifre Unregistered / Unconfirmed GUEST, unregistred user! 2009-10-21 #2 select a,b=(select b from aaa where a=kk.a and c=1 )+(select b from aaa where a=kk.a and c=2 )+(select b from aaa where a=kk.a and c=3 ) from aaa kkgroup by a呵呵，固定的可以，不固定可就不行了，根据实际数据看吧
select a,b=(select b from aaa where a=kk.a and c=1 )+(select b from aaa where a=kk.a and c=2 )+(select b from aaa where a=kk.a and c=3 ) from aaa kkgroup by a呵呵，固定的可以，不固定可就不行了，根据实际数据看吧
