PostgreSQL ORDER BY

PostgreSQL Notes · Coding Now Tech Institute1 min readSource

Sort Data

The ORDER BY keyword is used to sort the result in ascending or descending order.

The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

Example

SELECT * FROM products
ORDER BY price;

DESC

The ORDER BY keyword sorts the records in ascending order by default. To sort the records in descending order, use the DESC keyword.

Example

SELECT * FROM products
ORDER BY price DESC;

Sort Alphabetically

For string values the ORDER BY keyword will order alphabetically:

Example

SELECT * FROM products
ORDER BY product_name;

Alphabetically DESC

To sort the table reverse alphabetically, use the DESC keyword:

Example

SELECT * FROM products
ORDER BY product_name DESC;

PreviousPostgreSQL WHERE Next PostgreSQL LIMIT

Want to go beyond the notes?

Join Coding Now Tech Institute's PostgreSQL course — live mentorship, real projects, and 100% placement support.

Enroll Now — Free Demo Available

PostgreSQL ORDER BY – FAQs

Quick answers about learning PostgreSQL ORDER BY in PostgreSQL.

What does this PostgreSQL ORDER BY note cover?

This free note from Coding Now Tech Institute explains PostgreSQL ORDER BY in PostgreSQL — concept, syntax and worked code examples you can copy, run and revise before interviews.

Is this PostgreSQL ORDER BY tutorial free?

Yes. Every PostgreSQL topic on Coding Now Tech Institute, including PostgreSQL ORDER BY, is 100% free with no signup required.

How long does it take to learn PostgreSQL ORDER BY?

With focused practice, most students grasp PostgreSQL ORDER BY in 1–3 days from these notes; pairing it with Coding Now Tech Institute's mentor-led course takes you to job-ready depth faster.

Where can I practise PostgreSQL ORDER BY after reading?

Use the code examples in this note, then ask doubts for free on the Coding Now Tech Institute Community (/community) — expert instructors answer within 24 hours.