Oracle query with sum() in the where clause

Question

I have a table which consists two columns amount and description. Now i need something like Select description from tab where sum(amount) > 5000 Which is not possible i guess. Is there any custom method to get this done ?

Roger Cornejo · Accepted Answer · 2017-04-20 02:22:55Z

8

Try something like:

select description, sum(amount)
from tab
group by description
having sum(amount) > 5000
;

answered Apr 20, 2017 at 2:22

Roger Cornejo

1,5571 gold badge8 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ankit Over a year ago

Thanks a lot. I need one more help. Accounts table contains acno and acid. Tab consists of acid. To group the above query based on acno i should write. Select acno,description,sum(amount) from tab,accounts where accounts.acid=tab.acid group by acno,description having sum(amount) > 5000. ???

Collectives™ on Stack Overflow

Oracle query with sum() in the where clause

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related