SQL select distinct rows

Question

I have data like this (col2 is of type Date)

| col1 |        col2         |
------------------------------
|  1   | 17/10/2007 07:19:07 |
|  1   | 17/10/2007 07:18:56 |
|  1   | 31/12/2070          |
|  2   | 28/11/2008 15:23:14 |
|  2   | 31/12/2070          |

How would select rows which col1 is distinct and the value of col2 is the greatest. Like this

| col1 |        col2         |
------------------------------
|  1   | 31/12/2070          |
|  2   | 31/12/2070          |

Answer 1

SELECT col1, MAX(col2) FROM some_table GROUP BY col1;

Answer 2

 select col1, max(col2)
 from table
 group by col1

Answer 3

In Oracle and MS SQL:

SELECT  *
FROM    (
        SELECT  t.*, ROW_NUMBER() OVER (PARTITION BY col1 ORDER BY col2 DESC) rn
        FROM    table t
        ) q
WHERE rn = 1

This will select other columns along with col1 and col2

Answer 4

SELECT Col1, MAX(Col2) FROM YourTable GROUP BY Col1

Answer 5

i reckon it would be

select col1, max(col2) from DemoTable group by col1

unless i've missed something obvious

Answer 6

select col1, max(col2) from MyTable
group by col1