Logo 
Search:

Oracle Articles

Submit Article
Home » Articles » Oracle » Select QueryRSS Feeds

Display total of each invoices

Posted By: David Evans     Category: Oracle     Views: 1663

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!