I have a table with rows in it as below
Column1 Column2
4 50
4 60
6 30
6 90
6 70
7 200
7 100
And I would like to get the result of the query as
Column1 Column2
4 50
6 30
7 100
Can someone help me in writing a query for the above results...