In this post, you’ll learn about the DB2 error 169-A column has been specified more than once in the order by list. Columns 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 – A column has been specified more than once in the order by list. Columns 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.