表T如下DATE PERSON SEAT
20081201 A SEAT1
20081201 B SEAT2
20081201 C SEAT3
20081202 A SEAT3
20081202 B SEAT2
20081202 C SEAT1想查询出如下结果DATE SEAT1 SEAT2 SEAT3
20081201 A B C
20081202 C B A
20081201 A SEAT1
20081201 B SEAT2
20081201 C SEAT3
20081202 A SEAT3
20081202 B SEAT2
20081202 C SEAT1想查询出如下结果DATE SEAT1 SEAT2 SEAT3
20081201 A B C
20081202 C B A
DATE,
max(case when SEAT ='SEAT1' then PERSON else '' end) as SEAT1,
max(case when SEAT ='SEAT2' then PERSON else '' end) as SEAT2,
max(case when SEAT ='SEAT3' then PERSON else '' end) as SEAT3
from
t
group by DATE