Today I had to select a distinct column on a DB2 table but I also wanted the query ordered. When I tried select distinct title from product order by price, qty the sql compiler complained that it didn’t recognise the order by statement.
After a while of googling the problem, IBM came to the rescue. I found this page detailing how a achieve the desired result using a WITH statement (which I seem to be using a lot recently..).
So the correct syntax to order a distinct select in DB2 is
``` {.js name=”code”} with PRODUCT(title){ select distinct title from products }
select title from PRODUCT order by price,qty ```
I hope this helps anyone else who come across the same problem
Matt