Display itemname and total sales amount for each item.

Jitendrasoft09
Posted by Jitendrasoft09 under Oracle category on | Points: 40 | Views : 692
select itemname,sum(amount) from item group by itemname;

Comments or Responses

Login to post response