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