SELECT Name
,COUNT(1) NoOfScores
,MAX(Score)Max_Score
,MIN(Score)Min_Score
,ROUND(AVG(CAST(Score AS DECIMAL(18,2))),2,1)Avg_Score
FROM Table1
GROUP BY Name
,COUNT(1) NoOfScores
,MAX(Score)Max_Score
,MIN(Score)Min_Score
,ROUND(AVG(CAST(Score AS DECIMAL(18,2))),2,1)Avg_Score
FROM Table1
GROUP BY Name
解决方案 »
- 求一個查詢sql,兩時間相差排除星期六
- [Microsoft][ODBC SQL Server Driver]通讯链接失败.
- 帮我看看这么简单的语句。为什么错
- sql server连接oracle,怎么知道是哪个instance呢?
- 紧急求助,数据库有150G,连执行Select Count(1) From 表都执行不出结果了!!
- 如何在一条命令中同时检索两个数据库服务器上的表?
- 哪张系统表是记录哪个登陆帐号可以登陆哪个数据库的?
- SQL区分大小写
- 求助!!看看这个为什么有问题??
- VFP的查询locate支持多少条记录?sql语句如何输出到指定的text?
- TSQL 查询的难题。
- SQL中查询一天的刷卡记录,每天的刷卡记录都存在一张logtable表中
-- 可以改成
,ROUND(AVG(CAST(Score * 1.0)),2,1)Avg_Score
Percentile_Disc 的语法比较复杂:
PERCENTILE_DISC ( numeric_literal ) WITHIN GROUP ( ORDER BY order_by_expression [ ASC | DESC ] )
OVER ( [ <partition_by_clause> ] )
Percentile_Disc(0.6)WITHIN GROUP (ORDER BY Score)
貌似是最高分,百分60的效果
,COUNT(1) NoOfScores
,MAX(Score)Max_Score
,MIN(Score)Min_Score
,Percentile_Disc(0.6)WITHIN GROUP (ORDER BY Score) Over()
FROM Table1
GROUP BY Name报错: Column 'Table1.Score' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.