Hi here's a table
SELECT DISTINCT value FROM Table ORDER BY "order" DESC
But I get
So Disctinct doesn't respect the ORDER BY clause. That's very bad IMHO, am I wrong.
P.S : I think it order by recordid internally I guess, rather than from the order clause