DB2 Error Code 169 – Expression ‘1’ and ‘8’ in the ORDER BY list are same. Expressions in the ORDER BY list must be unique.

In this post, you’ll learn about the DB2 error 169-Expression ‘1’ and ‘8’ in the ORDER BY list are same. Expressions in the ORDER BY list must be unique. and the reason why you are receiving the error message and how to fix it

How does this Error Message Looks like

169 – Expression ‘1’ and ‘8’ in the ORDER BY list are same. Expressions in the ORDER BY list must be unique.

Reason for the Error & Solution

Ensure that there are no duplicates in the ordering of the query.