⑴ sql语句得出成绩排名为10到20名的学生
select 学生姓名 from 表 order by 学生成绩 desc
排序，指定分页大小是10，然后跳到第二页。
也就是相当于翻页嘛。
⑵ 在 SQL server中怎样设置成绩表中成绩字段的检查约束值为0到100之间
CHECK(成绩>=0 AND 成绩<=100)
⑶ SQL 约束 怎样写能让分数为空或必须是0~100之间
alter table tablename
add constraint CK_score CHECK(score BETWEEN 0 AND 100 OR score is NULL)
tablename 表名
score 分数
⑷ 在sql语言中，增加约束条件使stud_grade表中的grade在0到100之间
alter table stud_grade add constrant 约束名 check(grade between 1 and 100)
⑸ Sql表达式成绩分数约束表达式，空或必须是0~100之间怎么写
check(psd like '[NULL|0-100]')
⑹ 1查询成绩表的总分数，平均分，最低分和最高分。用sql语句怎么写
---1. 计算每个人的总成绩并排名（要求显示字段：姓名，总成绩）
select name,sum(cast(score as bigint)) as allscore from stuscore group by name order by allscore desc
---2. 计算每个人的总成绩并排名（要求显示字段: 学号，姓名，总成绩）
select stuid,name,sum(cast(score as bigint)) as allscore from stuscore group by stuid,name order by allscore desc
---3. 计算每个人单科的最高成绩(要求显示字段: 学号，姓名，课程，最高成绩)
SELECT t1.stuid,t1.name,t1.subject,t1.score from stuscore t1,(SELECT stuid,max(score) as maxscore from stuscore group by stuid) t2 where t1.stuid=t2.stuid and t1.score=t2.maxscore
---4. 计算每个人的平均成绩（要求显示字段: 学号，姓名，平均成绩）
select distinct t1.stuid,t1.name,t2.avgscore from stuscore t1,(select stuid,avg(cast(score as bigint)) as avgscore from stuscore group by stuid) t2 where t1.stuid=t2.stuid
---5. 列出各门课程成绩最好的学生(要求显示字段: 学号，姓名,科目，成绩)
select t1.stuid,t1.name,t1.subject,t2.maxscore from stuscore t1,(select subject,max(score) as maxscore from stuscore group by subject) t2 where t1.subject=t2.subject and t1.score=t2.maxscore
---6. 列出各门课程成绩最好的两位学生(要求显示字段: 学号，姓名,科目，成绩)
select distinct t1.* from stuscore t1 where t1.stuid in(select top 2 stuscore.stuid from stuscore where subject = t1.subject order by score desc)order by t1.subject
---7. 统计报表(要求显示字段: 学号，姓名，各科成绩，总分，平均成绩)
select stuid as 学号,name as 姓名,sum(case when subject='语文' then score else 0 end) as 语文,sum(case when subject='数学' then score else 0 end) as 数学,sum(case when subject='英语' then score else 0 end) as 英语,sum(cast(score as bigint)) as 总分,(sum(cast(score as bigint))/count(*)) as 平均分 from stuscore group by stuid,name order by 总分 desc
---8. 列出各门课程的平均成绩（要求显示字段：课程，平均成绩）
select subject,avg(cast(score as bigint)) as avgscore from stuscore group by subject
---9. 列出数学成绩的排名（要求显示字段：学号，姓名，成绩，排名）
select * from stuscore where subject ='数学' order by score desc
---10. 列出数学成绩在2-3名的学生（要求显示字段：学号，姓名,科目，成绩）
select t3.* from(select top 2 t2.* from (select top 3 name,subject,score,stuid from stuscore where subject='数学' order by score desc) t2 order by t2.score) t3 order by t3.score desc
---11. 求出李四的数学成绩的排名
declare @tmp table(pm int,name varchar(50),score int,stuid int)
insert into @tmp select null,name,score,stuid from stuscore where subject='数学' order by score desc
declare @id int
set @id=0;
update @tmp set @id=@id+1,pm=@id
select * from @tmp where name='李四'
---12. 统计各科目及格人数
select subject,
(select count(*) from stuscore where score<60 and subject=t1.subject) as 不及格,
(select count(*) from stuscore where score between 60 and 80 and subject=t1.subject) as 良,
(select count(*) from stuscore where score >80 and subject=t1.subject) as 优
from stuscore t1 group by subject
---13．统计如下：数学:张三(50分),李四(90分),王五(90分),赵六(76分)
declare @s varchar(1000)
set @s=''
select @s =@s+','+name+'('+convert(varchar(10),score)+'分)' from stuscore where subject='数学'
set @s=stuff(@s,1,1,'')
print '数学:'+@s
⑺ 用sql语句查将成绩小于60分的计算机专业学生的成绩设置为0
1、首先在sql软件附加有成绩表的数据库，然后右键新建查询。
⑻ sql语句列出成绩在80分到100分之间的学生名单
select * from 学生表 where 学生表主键id in (select 学生表学生id from 成绩表 where 成绩字段 between 80 and 100)
或
select * from 学生表 where 学生表主键id in (select 学生表学生id from 成绩表 where 成绩字段>=80 and 成绩字段<=100)
⑼ SQL查询学生成绩
--代码如下--
SELECTa.snameAS'姓名'
MAX(CASEb.sidWHEN'0001'THENb.scoreELSE0END)AS'语文'
MAX(CASEb.sidWHEN'0002'THENb.scoreELSE0END)AS'数学'
MAX(CASEb.sidWHEN'0003'THENb.scoreELSE0END)AS'英语'
FROMstudenta,scoresbONa.sid=b.sid
GROUPBYb.sid
⑽ 在 SQL server中怎样设置成绩表中成绩字段的检查约束值为0到100之间，用逻辑表达式来表示
CHECK(成绩>=0 AND 成绩<=100)