DISTINCT & LIMIT — Unique Records & Result Limiting — Free SQL Tutorial

TL;DR: Learn DISTINCT & LIMIT — Unique Records & Result Limiting in SQL with a free, beginner-friendly tutorial, examples and practice for Indian students on…

DISTINCT & LIMIT — Unique Records & Result Limiting in SQL

DISTINCT removes duplicate rows from results — shows each unique combination once. Useful for finding unique values or counts.

LIMIT restricts how many rows are returned. OFFSET skips rows (for pagination). Essential for performance on large datasets.

DISTINCT is applied before ORDER BY and LIMIT, so it's an expensive operation on large tables.

SELECT DISTINCT column FROM table;
SELECT DISTINCT col1, col2 FROM table;  -- unique pairs

SELECT * FROM table LIMIT 10;
SELECT * FROM table LIMIT 10 OFFSET 20;  -- rows 21-30

SELECT COUNT(DISTINCT column) FROM table;

Learn DISTINCT & LIMIT — Unique Records & Result Limiting step by step with Syllab's free interactive SQL tutorial — runnable code examples, practice exercises and instant AI feedback, all free with no signup. Explore the full SQL course →