Msg 8120 Level 16 - Column is invalid in the select list

Transact sql error message Msg 8120 Level 16 - Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.


Msg 8120 Level 16 Example:

Invalid select:

USE model;
GO
SELECT MAX(id), first_name, last_name FROM students;
GO

Message
Msg 8120, Level 16, State 1, Line 1
Column 'students.first_name' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Correct select:

USE model;
GO
SELECT MAX(id), first_name, last_name FROM students
GROUP BY first_name, last_name;
GO

Other error messages: