postgres
postgresql
programming
sql
query
find
[Edit]
EN
PostgreSQL - select first N rows
2 contributors
7 contributions
0 discussions
0 points
Created by:
255
In this article, we would like to show you how to find and selectthe first row from a table in PostgreSQL.
Quick solution:
SELECT "column1", "column2", "columnN" FROM "table_name" LIMIT N;Practical example
To show how to select the first N rowsfrom a table, we will use the following table:
Note:
At the end of this article you can find database preparation SQL queries.
Example 1 - select all columns
In this example, we will select all the information [columns]about the first 3users from the users table.
Query:
SELECT * FROM "users" LIMIT 3;Output:
Example 2 - select specified columns
In this example, we will findthe first 3 users id,name and emailcolumn information.
Query:
Output:
Example 3 - first row in some order
In this example, we will select the first row in some order.
SELECT * FROM "users" ORDER BY "name" LIMIT 3;Output:
Database preparation
create_tables.sqlfile:
CREATE TABLE "users" [ "id" SERIAL PRIMARY KEY, "name" VARCHAR[100] NOT NULL, "email" VARCHAR[100] NOT NULL, "country" VARCHAR[15] NOT NULL ];insert_data.sqlfile:
INSERT INTO "users" ["name", "email", "country"] VALUES ['Tom', '', 'Poland'], ['Chris', '', 'Spain'], ['Jack', '', 'Spain'], ['Kim', '', 'Vietnam'], ['Marco', '', 'Italy'], ['Kate', '', 'Spain'], ['Nam', '', 'Vietnam'];