Cheat Sheet logoCheat Sheet Today
SQL Cheat Sheet/Fetch first rows

Use standard SQL row limiting syntax.

Back to sheetBrowse commands
Sign in to save
Section: Sorting and Limiting

Fetch first rows

sql
sql
SELECT *
FROM employees
ORDER BY salary DESC
FETCH FIRST 10 ROWS ONLY;
Explanation

Supported in many modern SQL engines and part of the SQL standard.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Sorting and Limiting
Limit returned rows
Return only the first N rows.
OpenIn sheetsqlsame section
Paginate with LIMIT and OFFSET
Skip rows and return a page-sized result set.
OpenIn sheetsqlsame section
Sort rows
Order query results ascending or descending.
OpenIn sheetsqlsame section
Select all columns
Return all columns from a table.
OpenIn sheetsql
Filter with equality
Return rows matching an exact value.
OpenIn sheetsql
Inner join two tables
Return rows with matches in both tables.
OpenIn sheetsql