Tables can hold millions of rows, and often you only want the first few, like the top 3 earners or one page of results. LIMIT caps how many rows come back, and OFFSET skips rows for paging. Always pair it with ORDER BY, or "first 3" means any 3 rows. Note that SQL Server writes SELECT TOP 3 instead, a common interview MCQ.