Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Example of natural join

Posted By: Leticia Silva     Category: Oracle     Views: 4626

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!