晕。。
学生总数
select count(distinct no) from student
请选出学科是语文的所有学生的学号、姓名、成绩,并按学号排序
select no,name,achi from student where subject="语文" order by no
请选出语文成绩前十名学生的学号、姓名、成绩,并按成绩排序
select top 10 no,name,achi from student subject="语文" order by achi
请选出总成绩前十名学生的学号、姓名成绩,并按总成绩排序
select top 10 no,name,sum(achi) as sum_achi from student group by no,name order by sum_achi
学生总数
select count(distinct no) from student
请选出学科是语文的所有学生的学号、姓名、成绩,并按学号排序
select no,name,achi from student where subject="语文" order by no
请选出语文成绩前十名学生的学号、姓名、成绩,并按成绩排序
select top 10 no,name,achi from student subject="语文" order by achi
请选出总成绩前十名学生的学号、姓名成绩,并按总成绩排序
select top 10 no,name,sum(achi) as sum_achi from student group by no,name order by sum_achi
1.
Select Count(Distinct NO) As 学生个数 from student
2.
Select 学号,姓名,成绩 from student Where 学科=N'语文' Order By 学号
3.
Select TOP 10 学号,姓名,成绩 from student Where 学科=N'语文' Order By 成绩 Desc
4.
Select 学号,姓名,SUM(成绩) As 总成绩 from student Group By 学号,姓名 Order By 总成绩 Desc
2 select no ,name,achi from student where subject=语文 order by no
3 select tops no ,name,achi from student subject=语文 order by achi desc
请选出学科是语文的所有学生的学号、姓名、成绩,并按学号排序;
2>select * from student order by no where SUBJECT='語文'
3>请选出语文成绩前十名学生的学号、姓名、成绩,并按成绩排序;select * from student where achi in (select top 10 achi from student group by 成績
having subject='語文') order by achi desc
1.
Select Count(Distinct NO) As 学生个数 from student
2.
Select NO,NAME,SUBJECT from student Where SUBJECT=N'语文' Order By NO
3.
Select TOP 10 NO,NAME,ACHI from student Where SUBJECT=N'语文' Order By ACHI Desc
4.
Select NO,NAME,SUM(ACHI) As 总成绩 from student Group By NO,NAME Order By 总成绩 Desc
1.
Select Count(Distinct NO) As 学生个数 from student
2.
Select 学号,姓名,成绩 from student Where 学科=N'语文' Order By 学号
3.
Select TOP 10 学号,姓名,成绩 from student Where 学科=N'语文' Order By 成绩 Desc
---沒有考慮到成績相同的情況。
学科是语文的所有学生的学号、姓名、成绩,并按学号排序 select * from student where subject='语文' order by no
语文成绩前十名学生的学号、姓名、成绩,并按成绩排序 select top 10 * from student where subject='语文' order by no
总成绩前十名学生的学号、姓名成绩,并按总成绩排序;select no,achi from student where no in(select top 10 NO from student group by no order by sum(achi))