Answers for "How to select the nth row in a SQL database table?"

SQL
0

How to select the nth row in a SQL database table?

SELECT * FROM (
  SELECT
    ROW_NUMBER() OVER (ORDER BY key ASC) AS rownumber,
    columns
  FROM tablename
) AS foo
WHERE rownumber <= n
Posted by: Guest on July-24-2021

Code answers related to "How to select the nth row in a SQL database table?"

Code answers related to "SQL"

Browse Popular Code Answers by Language