Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display total of each invoices

Posted By: David Evans     Category: Oracle     Views: 2050

This article provides an example to display total of each invoices.

Code for Display total of each invoices in Oracle

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

Output:

INVNO     Total Price
-----     ------------
IN001 180000 IN002 1250 IN003 1100 IN004 30000 IN005 87500
  
Share: 


Didn't find what you were looking for? Find more on Display total of each invoices Or get search suggestion and latest updates.

David Evans
David Evans author of Display total of each invoices 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!