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

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!