Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Example of natural join

Posted By: Leticia Silva     Category: Oracle     Views: 5735

This article provides an example of natural join.

Code for Example of natural join in Oracle

Select invno, sum(qty), sum(qty*itemprice) "Item Price" from invitem, item where invitem.itemno=item.itemno groupby invno;

Output:

INVNO   SUM(QTY)  Item Price
------  --------  -----------
IN001 20 9000 IN002 50 1250 IN003 25 250 IN004 45 18000 IN005 22 15400
  
Share: 


Didn't find what you were looking for? Find more on Example of natural join Or get search suggestion and latest updates.

Leticia Silva
Leticia Silva author of Example of natural join is from Salvador, Brazil.
 
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!