简单sql问题 ( 积分: 20 )

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-15

• #1

select datepart(MONTH, BeginDate)as Pdate
from CheckStat group by pDate order by pDate
服务器: 消息 207，级别 16，状态 3，行 1
列名 'pDate' 无效。
怎么解决

 

Z

zhlu

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-15

• #2

select datepart(MONTH, BeginDate)as Pdate
from CheckStat group by datepart(MONTH, BeginDate) order by 1

 

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-05-15

• #3

接受答案了.