Remove duplicate records

Question

Hi All,

 

I have a table which has 2 columns lets say id1,id2 and data are like in below format

 

id1  id2

1      2

4      7

21    5

62    10

7       4

10     62

5       21

2       1 

 

i want unique data in below  output like

id1 id2

1     2

4     7

21    5

10    62

 

 or its like

 

id1  id2

2      1

7      4

5      21

62   10