sql select from an ordered table

Question

I want to ask some records from an ordered table.

select * from table_name order by something desc limit 4;

This is the error message (is the 'limit 4' line):

ORA-00933: SQL command not properly ended
00933. 00000 -  "SQL command not properly ended"
*Cause:    
*Action:
Error at Line: 7 Column: 1

@ShashankKadne - given the error code is `ORA-xxxxx` where the `xxxxx` is 5 digits, I'm 99.99% certain that its Oracle. — Damien_The_Unbeliever, Mar 25 '14 at 07:34
Try this `select * from table_name limit 4 order by something desc ;` — Amit, Mar 25 '14 at 07:35
I really wonder when they do "minus" for comments to downvote two previous comments... — smnbbrv, Mar 25 '14 at 07:42
Duplicate?: [SQL (ORACLE): ORDER BY and LIMIT](http://stackoverflow.com/q/7480243/456814). — , Aug 14 '14 at 08:22

Nagaraj S · Accepted Answer · 2014-03-25T07:58:02.353

2

use ROWNUM to limit the number of rows returned by a query

select * 
  (SELECT * FROM table_name ORDER BY someval desc)
 WHERE ROWNUM < 5;

edited Mar 25 '14 at 07:58

answered Mar 25 '14 at 07:36

Nagaraj S

1 Answers1