sql查询成绩前三名+top
@桑琪4262：请教sql语言,如何查询前三名学生...... -
颛光14735464597…… 信息没给足,, 成绩表通过什么字段和st_info 以及 c_info关联呢?? 以上信息不足,没法直接给你写完整的sql,只能给你个大致的语句供参考 select top 3 st_name,score from st_info,s_c_info..... where ...... order by score desc
@桑琪4262：如何用SQL语句检验＂显示总分前三名的学生记录＂ -
颛光14735464597…… select top 3 * from (select yuwen+shuxue+yingyu as zongfen,student.* from student) as k order by k.zongfen desc
@桑琪4262：用sql查询第三名到第五名的同学,怎么用呢? -
颛光14735464597…… 我们先分析一下,假设有一个表叫grade,里面有一列叫A,A中记录的是很多学生的成绩,那么我们可以采取这种办法求出第三名学生的成绩(嵌套三次查询语句): select min(A) AS A3 from grade where A>(select min(A) AS A2 from grade ...
@桑琪4262：数据库中查出表中最高到最低成绩的前3名的语句怎么写 -
颛光14735464597…… 最高成绩前3名:SELECT TOP 3 score FROM Marks ORDER BY score DESC(按成绩从高到低排列,取三位.) 最低成绩前3名:SELECT TOP 3 score FROM Marks ORDER BY score ASC
@桑琪4262：求一SQL语句:取每个班前三名,该怎么处理 -
颛光14735464597…… 1 2 3 4 5 6 表:sc成绩表(sno学号,cno课程号,score成绩) 代码: selecttop3 sum(score) fromsc groupbysno orderbysum(score) desc
@桑琪4262：用Sql查询男女成绩各前三名 -
颛光14735464597…… select * from ( select * from student s where s.sex='男' order by s.score desc) where rownum<=3 union select * from ( select * from student s where s.sex='女' order by s.score desc) where rownum<=3
@桑琪4262：SQL 查询语句 -
颛光14735464597…… 1:嵌套,先看最里面的 SELECT SNO,COUNT(SNO) AS CT FROM SC GROUP BY SNO 得到学号,和他选课的门数 SELECT CT FROM (SELECT SNO,COUNT(SNO) AS CT FROM SC GROUP BY SNO)AS T1(SNO,ct) GROUP BY CT HAVING...
@桑琪4262：mysql有一张成绩表(姓名)(班级)(成绩)三个字段,查出不同班级的成绩前三名的学生的分数 -
颛光14735464597…… select* from 成绩表 a where (select COUNT(1) FROM 成绩表 where 班级=a.班级 and 成绩>a.成绩)<=2
@桑琪4262：Access:有学生,课程,成绩三个表.用SQL语句查询各科最高分的学生的姓名,课号及成绩 -
颛光14735464597…… SQL语句: SELECT a1.* FROM (SELECT 成绩表.课程编码, 课程表.课程名称, 成绩表.学号, 学生表.姓名,成绩表.成绩 as 成绩 FROM (成绩表 LEFT JOIN 课程表 ON 成绩表.课程编码 = 课程表.课程编码) LEFT JOIN 学生表 ON 成绩表.学号 = 学生表.学号) AS a1 INNER JOIN (select 课程编码,max(成绩) as 最高分 from 成绩表 group by 课程编码) AS b1 ON (a1.课程编码 = b1.课程编码) AND (a1.成绩 = b1.最高分); 实例图: 查询结果
@桑琪4262：sql server 请教大家了,这个怎么排名出成绩前三的? -
颛光14735464597…… 1,select top 3 * from student order by _score desc2, select avg(_score) from student where _name='小王'3,select _bjmc from banji where id=(select bjid from student where _name='小张')4, select a.id,a.name,b.shl from banji a inner join (select bjid...
颛光14735464597…… 信息没给足,, 成绩表通过什么字段和st_info 以及 c_info关联呢?? 以上信息不足,没法直接给你写完整的sql,只能给你个大致的语句供参考 select top 3 st_name,score from st_info,s_c_info..... where ...... order by score desc
@桑琪4262：如何用SQL语句检验＂显示总分前三名的学生记录＂ -
颛光14735464597…… select top 3 * from (select yuwen+shuxue+yingyu as zongfen,student.* from student) as k order by k.zongfen desc
@桑琪4262：用sql查询第三名到第五名的同学,怎么用呢? -
颛光14735464597…… 我们先分析一下,假设有一个表叫grade,里面有一列叫A,A中记录的是很多学生的成绩,那么我们可以采取这种办法求出第三名学生的成绩(嵌套三次查询语句): select min(A) AS A3 from grade where A>(select min(A) AS A2 from grade ...
@桑琪4262：数据库中查出表中最高到最低成绩的前3名的语句怎么写 -
颛光14735464597…… 最高成绩前3名:SELECT TOP 3 score FROM Marks ORDER BY score DESC(按成绩从高到低排列,取三位.) 最低成绩前3名:SELECT TOP 3 score FROM Marks ORDER BY score ASC
@桑琪4262：求一SQL语句:取每个班前三名,该怎么处理 -
颛光14735464597…… 1 2 3 4 5 6 表:sc成绩表(sno学号,cno课程号,score成绩) 代码: selecttop3 sum(score) fromsc groupbysno orderbysum(score) desc
@桑琪4262：用Sql查询男女成绩各前三名 -
颛光14735464597…… select * from ( select * from student s where s.sex='男' order by s.score desc) where rownum<=3 union select * from ( select * from student s where s.sex='女' order by s.score desc) where rownum<=3
@桑琪4262：SQL 查询语句 -
颛光14735464597…… 1:嵌套,先看最里面的 SELECT SNO,COUNT(SNO) AS CT FROM SC GROUP BY SNO 得到学号,和他选课的门数 SELECT CT FROM (SELECT SNO,COUNT(SNO) AS CT FROM SC GROUP BY SNO)AS T1(SNO,ct) GROUP BY CT HAVING...
@桑琪4262：mysql有一张成绩表(姓名)(班级)(成绩)三个字段,查出不同班级的成绩前三名的学生的分数 -
颛光14735464597…… select* from 成绩表 a where (select COUNT(1) FROM 成绩表 where 班级=a.班级 and 成绩>a.成绩)<=2
@桑琪4262：Access:有学生,课程,成绩三个表.用SQL语句查询各科最高分的学生的姓名,课号及成绩 -
颛光14735464597…… SQL语句: SELECT a1.* FROM (SELECT 成绩表.课程编码, 课程表.课程名称, 成绩表.学号, 学生表.姓名,成绩表.成绩 as 成绩 FROM (成绩表 LEFT JOIN 课程表 ON 成绩表.课程编码 = 课程表.课程编码) LEFT JOIN 学生表 ON 成绩表.学号 = 学生表.学号) AS a1 INNER JOIN (select 课程编码,max(成绩) as 最高分 from 成绩表 group by 课程编码) AS b1 ON (a1.课程编码 = b1.课程编码) AND (a1.成绩 = b1.最高分); 实例图: 查询结果
@桑琪4262：sql server 请教大家了,这个怎么排名出成绩前三的? -
颛光14735464597…… 1,select top 3 * from student order by _score desc2, select avg(_score) from student where _name='小王'3,select _bjmc from banji where id=(select bjid from student where _name='小张')4, select a.id,a.name,b.shl from banji a inner join (select bjid...
