VIP会员
购物车
私信
发表新帖
立即签到SQL sever 入门级问题 with附近有语法错误
发表在Oracle视频答疑
2013-10-23
是否精华
是
否
版块置顶:
是
否
use test;
with agereps(age,agecount) as
(
select age,count(*)
from xuexichengji as agereps
where age is not null
group by age
)
select age,agecount
from agereps
[font color=#FF0000]服务器: 消息 156，级别 15，状态 1，行 2
在关键字 'with' 附近有语法错误。[/font]
with agereps(age,agecount) as
(
select age,count(*)
from xuexichengji as agereps
where age is not null
group by age
)
select age,agecount
from agereps
[font color=#FF0000]服务器: 消息 156，级别 15，状态 1，行 2
在关键字 'with' 附近有语法错误。[/font]
分享到：
关注
回复
支持(
反对(
