EN
PostgreSQL - sort in ascending or descending order
0 points
In this article, we would like to show you how to sort records in ascending and descending order in PostgreSQL.
Quick solution:
xxxxxxxxxx1
SELECT "column1", "column2", "columnN"2
FROM "table_name"3
ORDER BY "column1", "column2", "columnN" ASC;xxxxxxxxxx1
SELECT "column1", "column2", "columnN"2
FROM "table_name"3
ORDER BY "column1", "column2", "columnN" DESC;To show how to sort records in ascending and descending order, we will use the following table:
Note:
At the end of this article you can find database preparation SQL queries.
In this example, we will display information about the users in ascending salary order.
Query:
xxxxxxxxxx1
SELECT "name", "surname", "salary"2
FROM "users"3
ORDER BY "salary" ASC;Result:
In this example, we will display information about the users in descending salary order.
Query:
xxxxxxxxxx1
SELECT "name", "surname", "salary"2
FROM "users"3
ORDER BY "salary" DESC;Result:
create_tables.sql file:
xxxxxxxxxx1
CREATE TABLE "users" (2
"id" SERIAL,3
"name" VARCHAR(50) NOT NULL,4
"surname" VARCHAR(50) NOT NULL,5
"department_id" INTEGER,6
"salary" DECIMAL(15,2) NOT NULL,7
PRIMARY KEY ("id")8
);insert_data.sql file:
xxxxxxxxxx1
INSERT INTO "users"2
( "name", "surname", "department_id", "salary")3
VALUES4
('John', 'Stewart', 1, '3512.00'),5
('Chris', 'Brown', 2, '1344.00'),6
('Kate', 'Lewis', 3, '6574.00'),7
('Ailisa', 'Gomez', NULL, '6500.00'),8
('Gwendolyn', 'James', 2, '4200.00'),9
('Simon', 'Collins', 4, '3320.00'),10
('Taylor', 'Martin', 2, '1500.00'),11
('Andrew', 'Thompson', NULL, '2100.00');