新列命名问题?
(1)
select orderno,companyname,total,
(select sum(total) as //将sum(total)定义别名ordertotal
from dbo.order2
)
from dbo.order2
where companyname='a'
group by orderNo,companyname,total
为什么输出的时候无法显示ordertotal列名,显示的列名是“(无列名)”
(2)
SELECT OrderNo,companyname,total
FROM dbo.order2
WHERE companyname='uk02'
ORDER BY orderNO
compute sum(total)
有办法给compute语句中的sum()指定别名吗?
我用compute sum(total) as ordertotal 时
系统提示——在关键字 'as' 附近有语法错误。