I'm try to select only 10 row from a table by using limit
but it gives me an error,
My query is
SELECT *
FROM table_name
ORDER BY CUSTOMER
LIMIT 10
It gives an error :
ORA-00933: SQL command not properly ended
Can anyone guide me.
I'm try to select only 10 row from a table by using limit
but it gives me an error,
My query is
SELECT *
FROM table_name
ORDER BY CUSTOMER
LIMIT 10
It gives an error :
ORA-00933: SQL command not properly ended
Can anyone guide me.
You can use ROWNUM
:
SELECT *
FROM ( SELECT *
FROM table_name
ORDER BY CUSTOMER) t
WHERE ROWNUM <=10
For each row returned by a query, the ROWNUM pseudocolumn returns a number indicating the order in which Oracle selects the row from a table or set of joined rows. The first row selected has a ROWNUM of 1, the second has 2, and so on.
Or, since Oracle 12c r1, you can use FETCH
:
SELECT *
FROM table_name
ORDER BY CUSTOMER
FETCH FIRST 10 ROWS ONLY
FETCH
Use this clause to specify the number of rows or percentage of rows to return. If you do not specify this clause, then all rows are returned, beginning at row offset + 1.
FIRST | NEXT
These keywords can be used interchangeably and are provided for semantic clarity.