InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comThu, 20 Jun 2013 01:50:03 GMT20http://www.sqlservercentral.com/Forums/Topic1385037-391-1.aspxSELECT name as Name, SUM(population) as PopualtionFROM bbcWHERE population >1000GROUP BY name If you aggregate the specific column then other remaining column in the select list should be group by...Thu, 15 Nov 2012 03:34:29 GMTfarooq.hbshttp://www.sqlservercentral.com/Forums/Topic1385037-391-1.aspxIf your using an aggregate function in the select, you need to put in a group by clause of all the columns which are not encased in an aggregateSELECT name, SUM(population)FROM bbcWHERE population >1000GROUP BY nameThu, 15 Nov 2012 03:23:58 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1385037-391-1.aspxSAMPLE QUERY :SELECT name, SUM(population) FROM bbc where population >1000query failed and got error msg 8120ERROR "Column 'tt.dbo.bbc.name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause."I want to select name and corresponding sum (population) ..help???Thu, 15 Nov 2012 03:20:05 GMTsumith1andonly1