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

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

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

1

Source: stackoverflow.com

Similar codes

0 vote176 views1 answer
Call to undefined function mysql_query() in D:\xampp\htdocs\image\index.php:11 Stack trace: #0 {main} thrown in site:stackoverflow.com
SQL
0 vote218 views1 answer
Stop psql server windows
SQL
10 votes172 views2 answers
Linux command line import mysql database
SQL
31 votes201 views3 answers
Sql count
SQL
0 vote212 views1 answer
Oracle enable chain
SQL
0 vote207 views2 answers
How to drop mili second in sql
SQL
0 vote177 views1 answer
How to stop all connections to a psql 12 database?
SQL
5 votes206 views1 answer
Oracle create table comment
SQL
0 vote188 views1 answer
Org.apache.spark.sql.avro.IncompatibleSchemaException: Unexpected type org.apache.spark.ml.linalg.VectorUDT
SQL
0 vote190 views1 answer
Mysql select smaller of two values
SQL

Share