`Table1` has 3 columns: `col1`, `col2`, `col3`

How can I `SELECT` all the `DISTINCT` values of `col1` where `col3` equals a certain value, then sort it by `col2 DESC`, yet have the distinct `col1` results show their corresponding `col2` value?

I tried the following but it did not work:

```
SELECT DISTINCT (col1), col2
FROM  `Table1` 
WHERE  `col3` =  'X'
ORDER BY  `col2` DESC 

```

The above does not result in distinct values of `col1`. If I remove "`, col2`", then it will show distinct values of `col1`, but it won't show me their corresponding `col2` values.

So how do I do it?