Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere 10 - Error Messages » Database Error Messages » Alphabetic list of error messages

Function or column reference to '%1' in the ORDER BY clause is invalid Next Page

Function or column reference to '%1' must also appear in a GROUP BY


Item

Value

Constant

SQLE_INVALID_GROUP_SELECT

ODBC 2 State

37000

ODBC 3 State

42000

Parameter 1

Name of the column referenced directly, or in an expression, that must be in the GROUP BY clause.

Severity

15

SQLCODE

-149

SQLSTATE

53003

Sybase error code

7321

Probable cause

You used a non-aggregate function or column reference in the select list or in a nested query block that does not appear in the GROUP BY clause. In a query using GROUP BY, select list items that are not aggregate functions must also appear in the GROUP BY clause. If the select list item is a column reference or an alias, you may add the column name or alias to the GROUP BY clause. If the select list item is a scalar function, ensure that the function's arguments in the GROUP BY clause match exactly with those in the select list. In some cases, you may want to use the MAX function on the column name (or another aggregate function) instead of adding the column to the GROUP BY clause.