Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » OperatorsRSS Feeds

USING UNION WITH ORDER BY

Posted By: Brooke Hughes     Category: Oracle     Views: 2267

This article explains about using USING UNION WITH ORDER BY with example.

Customer - orders - salespeople database

USING UNION WITH ORDER BY

SELECT snum AS CODE,sname AS NAME FROM Salespeople WHERE city='ahmd'
UNION 
SELECT cnum,cname FROM Customers WHERE city='ahmd'
ORDER BY 2;

  
Share: 

 
 
 

Didn't find what you were looking for? Find more on USING UNION WITH ORDER BY Or get search suggestion and latest updates.

Brooke Hughes
Brooke Hughes author of USING UNION WITH ORDER BY is from London, United Kingdom.
 
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!