17,382
社区成员
发帖
与我相关
我的任务
分享Oracle里面怎么不能使用limit?
比如说我需要知道学生里面数学成绩前10名，并且要及格的学生资料。我是用这样的查询语句：
select * from student where math_scores > 60 order by math_scores limit 0,10
limit 0,10
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
select * from student where math_scores > 60 order by math_scores limit 0,10
limit 0,10
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
...全文
请发表友善的回复…
发表回复
lhz_9712 2004-06-22
- 打赏
- 举报
排序后用rownum <=10就行了
freddy2003 2004-06-22
- 打赏
- 举报
Oracle中的SQL,得到表中前10条记录怎么写？
select * from
(Select * from myTable where userId=10 order by CreateTime Desc )t
where rownum<=10
select * from
(Select * from myTable where userId=10 order by CreateTime Desc )t
where rownum<=10
