Home
PostgreSQL Order By

PostgreSQL Order By

PostgreSQL Order By

The PostgreSQL ORDER BY is used to sort the records of a select.

Order By syntax

SELECT * FROM table_name ORDER BY column_name ASC | DESC;

Order By example

Goods table

id good_type name description price
1 A Car_1 Car 1 description 100
2 A Car_2 Car 2 description 200
3 A Car_3 Car 3 description 100
4 B Boat_4 Boat 4 description 500
5 B Boat_5 Boat 5 description 300
6 C Train_1 Train 123 description 800 
select * from goods order by price asc;

Result

id good_type name description price
1 A Car_1 Car 1 description 100
3 A Car_3 Car 3 description 100
2 A Car_2 Car 2 description 200
5 B Boat_5 Boat 5 description 300
4 B Boat_4 Boat 4 description 500
6 C Train_1 Train 123 description 800 
select * from goods where price=100 order by id desc;

Result

id good_type name description price
3 A Car_3 Car 3 description 100
1 A Car_1 Car 1 description 100