Error: Column ” is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.


Error: Column ” is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Description: When a GROUP BY clause is used in the SELECT clause, each columns in the SELECT clause must be either defined via aggregated column or must be included in the GROUP BY clause.

Solution: Add all columns in the SELECT clause into the GROUP BY clause or remove the column that causing problem from the SELECT clause.

Advertisements

One thought on “Error: Column ” is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s