SQL selects individual rows

Question

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

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

How to select rows that col1 are different and col2 is the largest. 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

I believe it will be

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

if I did not miss something obvious

Answer 4

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

Answer 5

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

Answer 6

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