Order by Clause in PostgreSQL

Order by clause is used to sort the columns records in Ascending or Descending Order. Lets see the example : –

1. Employees Table Records
  • After Sorting first _name in Ascending Order
After Sorting first _name in Ascending Order
  • Sorting Salary Column records in Descending order
Sorting Salary Column records in Descending order
  • Sorting records of two columns, First_Name and Last_Name
Sorting records of two columns, First_Name and Last_Name

Post Author: adama