SQL Server error code

SQL Server error 8127

SQL Server raises error 8127 at severity 16, which marks a problem with the query or data that you can correct.

Column "%.*ls.%.*ls" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.