这个相当于把表变宽,可以使用自联结达到目的。假设表为test,select top 1a.name, a.addr, b.addr, c.addrfrom (select top 1 * from test where test.name='a' order by test.name) as a, test as b,test as cwhere
a.name=b.name and
b.name=c.name and
a.name='abc' and
a.addrb.addr and
b.addrc.addr and
a.addrc.addr...