Oracle select first 10 rows

SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC)
    WHERE ROWNUM >= 1 AND ROWNUM <=10;
-- Oracle 12c:
SELECT * FROM (SELECT [COLUMNS] FROM [TABLE] ORDER BY [DATE] DESC) 
    FETCH FIRST 10 ROWS ONLY;

Similar codes

8 votes292 views2 answers
Python simple connect to mysql
SQL
1 vote268 views3 answers
String to int mysql
SQL
0 vote278 views1 answer
Oracle create table auto generated primary key
SQL
5 votes305 views2 answers
Oracle find all tables with column name
SQL
2 votes278 views1 answer
How to add where command in update comand with joins
SQL
0 vote233 views1 answer
Online sql compiler
SQL
0 vote286 views1 answer
Mysql cast null to string
SQL
0 vote319 views3 answers
Select top 10 rows in sql
SQL
31 votes285 views4 answers
How to get duplicate records with multiple field in sql
SQL
5 votes262 views1 answer
Mysql select greater than yesterday
SQL