sql查询各科成绩第三名
@武支4943：SQL的自连接,比如要查询每科的前三名,查询语句是 -
父侨19121079103…… SELECT * FROM score a WHERE (SELECT count(*) FROM score b WHERE b.subjects=a.subjects)<3
@武支4943：用sql查询第三名到第五名的同学,怎么用呢? -
父侨19121079103…… 我们先分析一下,假设有一个表叫grade,里面有一列叫A,A中记录的是很多学生的成绩,那么我们可以采取这种办法求出第三名学生的成绩(嵌套三次查询语句): select min(A) AS A3 from grade where A>(select min(A) AS A2 from grade ...
@武支4943：请教sql语言,如何查询前三名学生...... -
父侨19121079103…… 信息没给足,, 成绩表通过什么字段和st_info 以及 c_info关联呢?? 以上信息不足,没法直接给你写完整的sql,只能给你个大致的语句供参考 select top 3 st_name,score from st_info,s_c_info..... where ...... order by score desc
@武支4943：如何用SQL语句检验＂显示总分前三名的学生记录＂ -
父侨19121079103…… select top 3 * from (select yuwen+shuxue+yingyu as zongfen,student.* from student) as k order by k.zongfen desc
@武支4943：oracle中的sql求总分前三名
父侨19121079103…… select name from ( select * from (select name,sum(mark) as zongfen from student group by name ) k order by zongfen desc ) z where rownum<=3;
@武支4943：sql查询第几名的语句 -
父侨19121079103…… select * from score as t1 where(select count(*) from score as t2 where t2.subject=t1.subject and t2.score>=t1.score)=3 错了,上面是每科成绩第三,看下面的select top 1 * from(select top 3 avg(score) as avgscore,name from score group by name order by avgscore desc) order by avgscore
@武支4943：用Sql查询男女成绩各前三名 -
父侨19121079103…… 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
@武支4943：sql查询第几名的语句 -
父侨19121079103…… sql语句如何查出表中第几行的数据如查找出第82503行的 谢谢问题补充:晕,select top 1 * from (select top 82503 * from table1 order by id) ,ganscE
@武支4943：一个表中 表名例如叫A 请问如何用一句sql语句查出三人的成绩按科目排序. -
父侨19121079103…… 创建数据表及数据 create table A(name varchar(10),fenshu int,kumu varchar(10)) insert into a values ('李雷',80,'数学') insert into a values ('李雷',65,'语文') insert into a values ('李雷',70,'英语') insert into a values ('林涛',87,'英...
父侨19121079103…… SELECT * FROM score a WHERE (SELECT count(*) FROM score b WHERE b.subjects=a.subjects)<3
@武支4943：用sql查询第三名到第五名的同学,怎么用呢? -
父侨19121079103…… 我们先分析一下,假设有一个表叫grade,里面有一列叫A,A中记录的是很多学生的成绩,那么我们可以采取这种办法求出第三名学生的成绩(嵌套三次查询语句): select min(A) AS A3 from grade where A>(select min(A) AS A2 from grade ...
@武支4943：请教sql语言,如何查询前三名学生...... -
父侨19121079103…… 信息没给足,, 成绩表通过什么字段和st_info 以及 c_info关联呢?? 以上信息不足,没法直接给你写完整的sql,只能给你个大致的语句供参考 select top 3 st_name,score from st_info,s_c_info..... where ...... order by score desc
@武支4943：如何用SQL语句检验＂显示总分前三名的学生记录＂ -
父侨19121079103…… select top 3 * from (select yuwen+shuxue+yingyu as zongfen,student.* from student) as k order by k.zongfen desc
@武支4943：oracle中的sql求总分前三名
父侨19121079103…… select name from ( select * from (select name,sum(mark) as zongfen from student group by name ) k order by zongfen desc ) z where rownum<=3;
@武支4943：sql查询第几名的语句 -
父侨19121079103…… select * from score as t1 where(select count(*) from score as t2 where t2.subject=t1.subject and t2.score>=t1.score)=3 错了,上面是每科成绩第三,看下面的select top 1 * from(select top 3 avg(score) as avgscore,name from score group by name order by avgscore desc) order by avgscore
@武支4943：用Sql查询男女成绩各前三名 -
父侨19121079103…… 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
@武支4943：sql查询第几名的语句 -
父侨19121079103…… sql语句如何查出表中第几行的数据如查找出第82503行的 谢谢问题补充:晕,select top 1 * from (select top 82503 * from table1 order by id) ,ganscE
@武支4943：一个表中 表名例如叫A 请问如何用一句sql语句查出三人的成绩按科目排序. -
父侨19121079103…… 创建数据表及数据 create table A(name varchar(10),fenshu int,kumu varchar(10)) insert into a values ('李雷',80,'数学') insert into a values ('李雷',65,'语文') insert into a values ('李雷',70,'英语') insert into a values ('林涛',87,'英...
