How to find the Nth record from the sql table #sql #sqlqueries #sqlserver #coding #shorts

How to find the Nth record from the sql table #sql #sqlqueries #sqlserver #coding #shorts #programming #youtubeshorts

[pankajparmar]

select * from table name order by column name limit 1 offset 6;

[scrachatron]

What an interview question 😂

The answer given is fine but I'd definitely question the interviewer with data stored in a properly normalised database shouldn't be every queried by row number it should be queried by ID, that's much better practice.

[sambanelluri]

SELECT TOP 9 *
FROM employee
ORDER BY empid ASC;

[mbeloch]

Why not just select * from table where id=n ?