Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display customers detail in a ascending order of customer name using order by clause in a select query

Posted By: Madison Campbell     Category: Oracle     Views: 3719

This article provides an example to display customers detail in a ascending order of customer name using order by clause in a select query.

Code for Display customers detail in a ascending order of customer name using order by clause in a select query in Oracle

select  * from cust orderby cname;

Output:

CUSTNO    CNAME     STATE        PHONE         CITY 
-------   -------   -------      ----------    ------
C0001 Ashish Gujarat 9999988888 Anand C0002 Dhaval Maharashtra 9898989898 Mumbai C0003 Dipen MP 9895989598 Bhopal C0004 Hardik UP 9998989899 Lucknow C0005 Jigar Rajasthan 9898999598 Jaipur
  
Share: 



Madison Campbell
Madison Campbell author of Display customers detail in a ascending order of customer name using order by clause in a select query is from Toronto, Canada.
 
View All Articles

 
Please enter your Comment

  • Comment should be atleast 30 Characters.
  • Please put code inside [Code] your code [/Code].

 
No Comment Found, Be the First to post comment!