Oracle 中没有order by,但我要对成绩进行排序要怎么弄?谢谢
解决方案 »
- Failed to unlock all EM-related accounts
- 怎么在Oracle10g中删除一个用户的所有表
- 求一sql 语句或者存储过程也可以
- 被一个弱弱的问题疯狂郁闷,求各位指点
- 如何查询package中函数及存储过程的详细信息
- 如何直接修改oracle数据文件恢复被delete掉的记录
- 关于两个数据库之间通过database link来访问的问题
- 怎样把一个数据库中的某个表的所有数据导出来,再导入到另个数据库中的相同结构的表中?
- 关于oracle事务的问题,挺奇怪的
- 要学oracle的话,什么书比较实用
- /*+rule*/
- 谁有ORACLE FOR VISTA的请联系QQ:81194882谢谢
select * from table1 order by score
where STUDNO IN(SELECT STUDNO FROM STUDSCOREINFO
GROUP BY STUDNO ORDER BY STUDSCORE DESC) WHERE rownum <= 5
AND STUDNO LIKE '20010505%'第 3 行出现错误:
ORA-00907: 缺失右括号为什么会出这个错误?明明没少括号
select * from STUDSCOREINFO
where STUDNO IN(SELECT STUDNO FROM STUDSCOREINFO
GROUP BY STUDNO ORDER BY STUDSCORE DESC) AND rownum <= 5
AND STUDNO LIKE '20010505%'第 3 行出现错误:
ORA-00907: 缺失右括号
那样不行啊,问题是这样的“在学生成绩信息表(StudScoreInfo)中查询学号为20010505 开头名列前5 名的学生信息”
[/Quote]
SELECT * FROM
(SELECT * FROM studscoreinfo WHERE studno LIKE '20010505%' ORDER BY studscore DESC)
WHERE ROWNUM < 6;[
where STUDNO IN(SELECT STUDNO FROM STUDSCOREINFO
GROUP BY STUDNO ORDER BY sum(STUDSCORE) DESC) AND rownum <= 5
AND STUDNO LIKE '20010505%'分组了却没有聚合,所以出错
select * from STUDSCOREINFO
where STUDNO IN(select studno from(
SELECT STUDNO FROM STUDSCOREINFO
GROUP BY STUDNO ORDER BY sum(STUDSCORE) DESC) where rownum <= 5 )
where STUDNO LIKE '20010505%'
FROM (SELECT *
FROM STUDSCOREINFO
WHERE STUDNO LIKE '20010505%'
ORDER BY STUDSCORE DESC)
WHERE ROWNUM < 6;