这个查询语句该怎样写，大家给点意见！(100分)

W

weibinggui

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-19

• #1

客户 &nbsp;订单日期 &nbsp; &nbsp; &nbsp;订单金额 <br>A &nbsp; &nbsp; &nbsp;2008-01-01 &nbsp; 5000<br>A &nbsp; &nbsp; &nbsp;2007-01-01 &nbsp; 10000<br>B &nbsp; &nbsp; &nbsp;2008-01-01 &nbsp; 10000<br>B &nbsp; &nbsp; &nbsp;2007-01-01 &nbsp; 300<br>想得到结果<br>客户名称 &nbsp;07年订单金额 &nbsp;08年订单金额<br>A &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10000 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5000<br>B &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;300 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;10000<br>这个过程应该怎样写？

 

S

szhcracker

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-19

• #2

竖变横

 

K

kaida

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-19

• #3

SELECT [客户],<br>[07年订单金额]=sum(case when YEAR([订单日期])=2007 then [订单金额] else 0 end),<br>[08年订单金额]=sum(case when YEAR([订单日期])=2008 then [订单金额] else 0 end)<br>FROM @T <br>GROUP BY [客户]

 

李

李翔鹏

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-19

• #4

楼上正确

 

W

weibinggui

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-20

• #5

多人接受答案了。

 

K

kaida

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-20

• #6

楼主有毛病，看来以后不能给出代码。

 

W

weibinggui

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-20

• #7

？答者都有分，你是50分，其它人一个是20分，一个是30分，我有什么毛病？

 

K

kaida

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-20

• #8

谁50？看来你是看错了，没关系，只要不是成心的，分数无所谓的。我为上面的语言道歉。

 

Q

qingangmail

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2008-09-24

• #9

答案正确