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.
