SELECT owner, COUNT(id) AS Expr1, DAY(addtime) AS Expr2
FROM housesource
WHERE (addtime BETWEEN '2004-11-01' AND '2004-11-30')这句有错误吧???
FROM housesource
WHERE (addtime BETWEEN '2004-11-01' AND '2004-11-30')这句有错误吧???
解决方案 »
- 急!SQL2888
- varchar(60)的字段,30万数据,用Contains,还是Like
- SQL SERVER安装报错:以前的个程序已在安装计算机上创建挂起的文件操作,
- 》》》》》》》》求教库存流水的问题
- 在SQL Server里,除了使用自增型ID外,还有什么方法可以取得唯一ID
- 在线等 一个identity的问题
- 如何禁止SQL远程连接!请允许本机连接!
- 这样的触发器怎样写?在线等...........................
- 如何判断游标已指向最后一条记录?
- 请教:用mdf怎么恢复或者建立一个完整的数据库,急,谢谢大家
- 求一SQL语句
- 能不能让一个存储过程,既能返回一个查询的数据集,另外还返回一个参数
FROM housesource
WHERE (addtime BETWEEN '2004-11-01' AND '2004-11-30')
GROUP BY DAY(addtime), owner
SELECT owner, COUNT(id) AS Expr1, DAY(addtime) AS Expr2
FROM housesource
WHERE (addtime BETWEEN '2004-11-01' AND '2004-11-30')
group by owner,addtime
select (select ...) n1,
(select ...) n2,
...
[1]=sum(case aa.Expr2 when '1' then Expr1 else 0 end),
[2]=sum(case aa.Expr2 when '2' then Expr1 else 0 end),
...
[30]=sum(case aa.Expr2 when '30' then Expr1 else 0 end)
from (SELECT owner, COUNT(id) AS Expr1, DAY(addtime) AS Expr2
FROM housesource
WHERE (addtime BETWEEN '2004-11-01' AND '2004-11-30')
GROUP BY DAY(addtime), owner
) aa
group by aa.owner
用您的方法可以实现,想问一下如果数据量有1万条左右的话,效率怎么样呢?
[1]=sum(case DAY(addtime) when '1' then COUNT(id) else 0 end),
[2]=sum(case DAY(addtime) when '2' then COUNT(id) else 0 end),
...
[30]=sum(case DAY(addtime) when '30' then COUNT(id) else 0 end),
DAY(addtime) AS Expr2
from housesource
WHERE (addtime BETWEEN '2004-11-01' AND '2004-11-30')
group by DAY(addtime), owner