Sql first

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

Similar codes

0 vote119 views1 answer
What is top n result in sql
SQL
9 votes110 views4 answers
How to alter table column name in mysql
SQL
0 vote119 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
0 vote116 views1 answer
Postgresql in vs any performance
SQL
2 votes112 views1 answer
Sql column values comma separated
SQL
2 votes128 views1 answer
Grant revoke privileges to mysql username
SQL
31 votes112 views3 answers
Sql count(*)
SQL
0 vote111 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote119 views1 answer
How to create a table based on another table in mysql
SQL
7 votes107 views5 answers
Oracle alter table
SQL