How do you retrieve the first N records in SQL?

To retrieve the first N records in SQL, the exact syntax depends slightly on the database system, but the goal is the same — limit the number of rows returned from a query.

In SQL Server, I typically use the TOP keyword:

SELECT TOP 5 * 
FROM Employees;

This returns the first 5 records from the Employees table. I often use this during testing or data preview — for instance, when verifying data quality after a migration or when I just want to inspect a small portion of a large dataset without loading everything.

In MySQL or PostgreSQL, the equivalent is the LIMIT clause:

SELECT * 
FROM Employees 
LIMIT 5;

This also returns the first 5 rows. I’ve used this approach frequently in dashboards where users only need to see a few top results — for example, “Top 10 Customers by Sales.”

In Oracle, the traditional way was using ROWNUM:

SELECT * 
FROM Employees 
WHERE ROWNUM <= 5;

However, in newer versions (12c and later), Oracle also supports FETCH FIRST N ROWS ONLY, which aligns with standard SQL:

SELECT * 
FROM Employees 
FETCH FIRST 5 ROWS ONLY;

A key point here is that SQL tables represent unordered sets — so unless you specify an ORDER BY clause, “first N records” is arbitrary. For example:

SELECT TOP 5 * 
FROM Employees 
ORDER BY HireDate ASC;

This ensures I’m getting the earliest hired 5 employees, not just any 5 rows.

A challenge I’ve faced was when working with paginated queries — for example, fetching rows 11 to 20 instead of just the top 10. In those cases, I use OFFSET with LIMIT:

SELECT * 
FROM Employees 
ORDER BY EmpID 
LIMIT 10 OFFSET 10;

That retrieves records starting from the 11th.

In short:

• SQL Server: TOP N
• MySQL/PostgreSQL: LIMIT N
• Oracle: FETCH FIRST N ROWS ONLY or ROWNUM

And I always pair it with ORDER BY to ensure consistent, predictable results — especially when the query is used in production reports or dashboards.