SQL 2023 · Querying
Sort and limit
Return the 10 newest rows. SQL Server uses TOP and Oracle uses FETCH FIRST.
SELECT * FROM posts ORDER BY created_at DESC LIMIT 10;
Official SQL 2023 documentation
SQL 2023 · Querying
Return the 10 newest rows. SQL Server uses TOP and Oracle uses FETCH FIRST.
SELECT * FROM posts ORDER BY created_at DESC LIMIT 10;
Official SQL 2023 documentation
Was this page helpful?