select
rtrim(SalesPerson) as '业务员',
sum(TurnOverPrice) as '业务额(万)',
count(SalesPerson) as '销量'
from Sales
group by SalesPerson , TurnOverPrice
order by TurnOverPrice desc我现在只想对“SalesPerson ”字段分组,怎么设计这个select语句?
rtrim(SalesPerson) as '业务员',
sum(TurnOverPrice) as '业务额(万)',
count(SalesPerson) as '销量'
from Sales
group by SalesPerson , TurnOverPrice
order by TurnOverPrice desc我现在只想对“SalesPerson ”字段分组,怎么设计这个select语句?
解决方案 »
- 求一个数量排前三记录的SQL查询语句
- 求一Sql语句
- 质量奖励和质量处罚,是设两个字段好呀,还是设计成一个字段,对于奖励存贮正值或对于处罚存贮负值呀?
- 救命啊!数据库日志文件损坏,怎么办?100分求救
- 求一个SQL语法-在线等,(多表合成一个表A,再与另一表合成一个表,显示表A所有记录)
- 在线请教关于sql中的检索文本语句
- 如何用select 对存储过程的返回记录集进行再次查询??
- 求助:关于SQL2000+Win2000分布式应用的问题,MSDTC 不可用。
- 请问MSSQ的DECIMAL和NUMERIC数据类型有什么区别?分别有什么用途?
- 欢迎SQL SERVER爱好者测试、使用DBTWIN数据库集群系统
- FIELDTERMINATOR ROWTERMINATOR 是什么意思啊?
- sql server2005 数据类型的疑问
TurnOverPrice 去掉
select
rtrim(SalesPerson) as '业务员',
sum(TurnOverPrice) as '业务额(万)',
count(SalesPerson) as '销量'
from Sales
group by SalesPerson
order by TurnOverPrice desc
select
rtrim(SalesPerson) as '业务员',
sum(TurnOverPrice) as '业务额(万)',
count(SalesPerson) as '销量'
from Sales
group by SalesPerson
order by TurnOverPrice desc
是不是这样?
如果这样写,会提示“TurnOverPrice”不包含在group by 子句中。
rtrim(SalesPerson) as '业务员',
sum(TurnOverPrice) as '业务额(万)',
count(SalesPerson) as '销量'
from Sales
group by rtrim(SalesPerson)
order by rtrim(SalesPerson) desc
rtrim(SalesPerson) as '业务员',
sum(TurnOverPrice) as '业务额(万)',
count(SalesPerson) as '销量'
from Sales
group by SalesPerson
order by 1 desc