select expr2, sum(expr3)
from
(SELECT address AS Expr1, MAX(DISTINCT STAGE) AS Expr2,
MAX(DISTINCT REVENUE) AS Expr3
FROM report
WHERE (CREATOR = 'bj40')
GROUP BY address ) as A
group by expr2
from
(SELECT address AS Expr1, MAX(DISTINCT STAGE) AS Expr2,
MAX(DISTINCT REVENUE) AS Expr3
FROM report
WHERE (CREATOR = 'bj40')
GROUP BY address ) as A
group by expr2
解决方案 »
- 客户端怎样存取sqlserver服务器电脑上的文件夹中的图片?
- 求sql 语句给存储过程传参
- |zyciis| 如何在各种数据库语句中识别出数据库名称,谢谢
- 有一张表建了四个索引算不算多,对表的性能影响有多大
- 用备份还原的方式在同一台服务器上建一个当前数据库的备份出现置疑
- 不用游标,用function实现,一个表五条记录,a,b,c,d,e,返回字符串“a,b,c,d,e,”
- SQL 关于exec问题
- sql2008 建立用户名后无法连接
- ******存储过程调用返回相应表的记录条数错误,请达人指点******
- MS-SQL Server 2003-06专家榜
- ORDER BY 的问题 (简单)
- 要根据某个字段统计语句怎么写?
MAX(DISTINCT REVENUE) AS Expr3
into #temp FROM report
WHERE (CREATOR = 'bj40')
GROUP BY address
go
select Expr2,sum(Expr3) from #temp
go
drop table #temp
SELECT address AS Expr1, MAX(DISTINCT STAGE) AS Expr2,
MAX(DISTINCT REVENUE) AS Expr3
into #temp FROM report
WHERE (CREATOR = 'bj40')
GROUP BY address
go
select Expr2,sum(Expr3) from #temp group by Expr2
go
drop table #temp