SELECT DISTINCT box AS 号码, SUM(CONVERT(float,charge)) AS 费用
FROM abcd
WHERE (LEFT(starttime, 8) BETWEEN '20080101' AND '20081231')
GROUP BY fc_box
ORDER BY SUM(CONVERT(float,charge)) desc,fc_box asc
FROM abcd
WHERE (LEFT(starttime, 8) BETWEEN '20080101' AND '20081231')
GROUP BY fc_box
ORDER BY SUM(CONVERT(float,charge)) desc,fc_box asc
解决方案 »
- SQL基础问题
- 两个问题一起问拉
- 请问,如何优化not in?
- if exists(select * from table1),如果table1里有5000万条记录,selecct语句只是监测到有1条就返回,还是会把5000万条都select一遍才返回
- 求教->触发器与存储过程
- 取字符串的SQL语句请大家帮忙
- sql server 2005按位'非'运算
- 大家帮忙看一下 nvarchar 转换为 uniqueidentifier 时出错 怎么解决
- 急寻 数据库安全方面的英文资料(5000字左右)!
- sqlserver 查询数据量到达临界值 cpu 100%
- SQL 并列表字段
- 外键约束的问题,请高手解答!解决后立即结帖!在线等!
(SELECT DISTINCT box AS 号码, SUM(CONVERT(float,charge)) AS 费用
FROM abcd
WHERE (LEFT(starttime, 8) BETWEEN '20080101' AND '20081231')
GROUP BY fc_box
ORDER BY fc_box)a
order by 费用 desc