Oracle ORDER BY ClauseIn Oracle, ORDER BY Clause is used to sort or re-arrange the records in the result set. The ORDER BY clause is only used with SELECT statement. Syntax: Parameters:expressions: It specifies columns that you want to retrieve. tables: It specifies the table name from where you want to retrieve records. conditions: It specifies the conditions that must be fulfilled for the records to be selected. ASC: It is an optional parameter that is used to sort records in ascending order. DESC: It is also an optional parameter that is used to sort records in descending order. Oracle ORDER BY Example: (without ASC/DESC attribute)Let's take a table "supplier" Supplier table: Execute this Query: Output: The above example returns the first_name ordered by last_name in ascending order. Oracle ORDER BY Example: (sorting in descending order)If you want to sort your result in descending order, you should use the DESC attribute in your ORDER BY clause: Execute this Query: Output The above example returns the first_name ordered by last_name in descending order. Next TopicOracle GROUP BY Clause |