Sybase Error – Function or column reference to ‘%1’ in the ORDER BY clause is invalid

In this blog post, you’ll learn more about the Sybase Error Function or column reference to ‘%1’ in the ORDER BY clause is invalid and the reason for receiving this error

Sybase SQL Error Message

Function or column reference to ‘%1’ in the ORDER BY clause is invalid

Reason for this Error

You specified a function or column reference in the ORDER BY clause that is semantically invalid. For example, for DISTINCT queries the ORDER BY clause may only refer to items in the query’s SELECT list.