Suggest an editImprove this articleRefine the answer for “How do you return only the first 10 records?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)To return only the first 10 records, the `LIMIT` keyword is used, e.g. `SELECT * FROM Employees LIMIT 10;`; SQL Server uses `TOP` instead (`SELECT TOP 10 * FROM Employees;`). **Key point:** it's usually paired with `ORDER BY`, to define which records count as "first" by the criterion you need.Shown above the full answer for quick recall.Answer (EN)ImageTo return **only the first 10 records**, the `LIMIT` keyword is used in SQL. **Example:** ```sql SELECT * FROM Employees LIMIT 10; ``` ### What this query does - Returns the **first 10 rows** of the `Employees` table. - The rest of the records are ignored. **Tips:** - Usually paired with `ORDER BY`, to define which records count as "first": ```sql SELECT * FROM Employees ORDER BY Age DESC LIMIT 10; ``` - Different DBMSs can also use `TOP` (SQL Server): ```sql SELECT TOP 10 * FROM Employees; ``` > Put simply, `LIMIT 10` lets you **pull just the first 10 records** from a table, in the given order.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.