DB2 Error Code – -208 the order by clause is invalid because column name is not part of the result table

In this post, you’ll learn about the error message -208 the order by clause is invalid because column name is not part of the result table in the IBM DB2 database , the reason why it occurs along with the solution to fix it

IBM DB2 Error Message

-208 the order by clause is invalid because column name is not part of the result table

Reason for the Error

The statement is invalid because a column (‘name’) specified in the ORDER BY list does not appear in the result table (that is, is not specified in the SELECT-list).� Only columns that are to appear in the result table can be used in ordering that result.

Solution

Correct the syntax of the statement, either by adding the specified column to the result table, or deleting it from the ORDER BY clause.