ORDER BY

---

Oracle - Order By

In 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 :

SELECT expressions  
FROM tables  
WHERE conditions  
ORDER BY expression [ ASC | DESC ];   

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:

  
  

  CREATE TABLE  "SUPPLIER"   
     (    "SUPPLIER_ID" NUMBER,   
      "FIRST_NAME" VARCHAR2(4000),   
      "LAST_NAME" VARCHAR2(4000)  
     )  
  /  
  

  
  

  SUPPLIER_ID	FIRST_NAME	LAST_NAME
  1	Ranveer	Desai
  2	Noel	Sean
  3	Renu	Kapoor

  
  

  Execute this Query:

  
  

  SELECT *  
  FROM supplier  
  ORDER BY last_name; 
  

  
  

  Output:

  
  

  SUPPLIER_ID	FIRST_NAME	LAST_NAME
  1	Ranveer	Desai
  3	Renu	Kapoor
  2	Noel	Sean

  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:

  SELECT *  
  FROM supplier  
  ORDER BY last_name DESC;  
  

  
  

  Output :

  SUPPLIER_ID	FIRST_NAME	LAST_NAME
  2	Noel	Sean
  3	Renu	Kapoor
  1	Ranveer	Desai

  The above example returns the first_name ordered by last_name in descending order.

  
  
  

  What Is Oracle

  What Is Oracle

  posted on 2019-11-29 01:11:21 - ORACLE Tutorials

  
  

  TRIGGER

  ORACLE - Trigger

  posted on 2019-11-28 22:14:22 - ORACLE Tutorials

  
  

  CURSOR

  ORACLE - Cursor

  posted on 2019-11-28 22:13:54 - ORACLE Tutorials

  
  

  Prompt Examples

  ChatGPT Prompt Examples

  posted on 2023-06-21 22:37:19 - ChatGPT Tutorials

  
  

  Use Cases

  Chat GPT Key Use Cases

  posted on 2023-06-21 21:03:17 - ChatGPT Tutorials

  
  

  Prompt Frameworks

  Prompt Frameworks

  posted on 2023-06-21 19:33:06 - ChatGPT Tutorials