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

2 votes126 views1 answer
Oracle index size calculation
SQL
0 vote141 views1 answer
How to import pymysql through jupyter notebook for windows
SQL
0 vote133 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote135 views3 answers
Sql drop all tables
SQL
0 vote102 views1 answer
Postgres create database if not exists
SQL
1 vote169 views1 answer
Apex run 404
SQL
3 votes130 views1 answer
Ms sql skip take
SQL
0 vote136 views1 answer
Get number of tables in database sql
SQL
3 votes145 views6 answers
DB::table('users')->get();
SQL
0 vote129 views1 answer
Insert or update cassandra
SQL