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: 20048 Registered: 06-2004 Rating: N/A Votes: 0 Posted on Monday, June 18, 2012 - 10:08 pm:    if I write the query like this, it is working good kaani I need other column names also in select that are not in group by. ela raayali? select project_id from table_name where 1 = 1 having sum(amount1) = 0 and sum(amount2) = 0 group by project_id