Subqueries Development Tutorials, Guides & Insights

Use LIMIT to restrict the number of rows returned by a query, especially for large datasets.

SELECT first_name, last_name FROM users LIMIT 10;

• ROW_NUMBER(): Assigns unique sequential numbers.
• RANK(): Assigns ranks with gaps on ties.
• DENSE_RANK(): Ranks without gaps.
• NTILE(n): Divides rows into n groups.
• LEAD() / LAG(): Accesses next/previous rows.

SELECT column1, window_function() OVER (PARTITION BY column ORDER BY column)
FROM table;