Query failed (aggregate function or the GROUP BY clause)

• sumith1andonly1

  SSCrazy

  Points: 2250

  More actions

  November 15, 2012 at 3:20 am

  #265435

  SAMPLE QUERY :

  SELECT name, SUM(population)

  FROM bbc

  where population >1000

  query failed and got error msg 8120

  ERROR

  "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???

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  November 15, 2012 at 3:23 am

  #1559258

  If 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 aggregate

  SELECT name, SUM(population)

  FROM bbc

  WHERE population >1000

  GROUP BY name

• farooq.hbs

  SSCrazy

  Points: 2083

  More actions

  November 15, 2012 at 3:34 am

  #1559263

  SELECT name as Name, SUM(population) as Popualtion

  FROM bbc

  WHERE population >1000

  GROUP BY name

  If you aggregate the specific column then other remaining column in the select list should be group by...