sql 命名问题

来源:互联网 发布:穿过的丝袜淘宝这么搜 编辑:程序博客网 时间:2024/06/07 11:46

正确的:select isnull(money,0) from (select  sum(money) as money,3 as b from zhangbenjilu where datepart(month,usedatetime)=3) as a

 

 

错误的:select isnull(money,0) from (select  sum(money) as money,3  from zhangbenjilu where datepart(month,usedatetime)=3)

原创粉丝点击