lnreddy is right I want total of sum(mat_amount) at the end.
sum(mat_amount)
100
200
300
----------
600 total sum(sum(mat_amount))... how do I get this ????
I am using Oracle 8.
Yes, indexes could be a problem I am looking at it.