Rate this post by selecting a number. 1 is the worst and 5 is the best.

Author Message   Ravanabrahma Mudiripoyina Bewarse Username: Ravanabrahma Post Number: 20049 Registered: 06-2004 Rating: N/A Votes: 0 Posted on Monday, June 18, 2012 - 10:11 pm:    eyyy..raasesa..below query is working select * from test_debug a where 1 = 1 and exists (select project_id from test_debug b where 1 = 1 and a.project_id = b.project_id having sum(amount1) != 0 and sum(amount2) != 0 group by project_id)