to delete one of 2 same records

[ssathyaa]

look
if my table is as follows
A B
------ ----------
1 1
2 2
1 2
1 1
1 2
1 2

now i want to display the records that are duplicated
( not to consider the table will have only 2 columns it can have n columns)

the o/p should be
A B
-------- --------
1 1
1 2

and now how to make the table as
A B
-------- --------
1 1
1 2
2 2

[r035198x]

look
if my table is as follows
A B
------ ----------
1 1
2 2
1 2
1 1
1 2
1 2

now i want to display the records that are duplicated
( not to consider the table will have only 2 columns it can have n columns)

the o/p should be
A B
-------- --------
1 1
1 2

and now how to make the table as
A B
-------- --------
1 1
1 2
2 2

Hi and welcome to TSDN.
Which database are you using? If you post this in the relevant database forum, you'll get a response quicker.

[bartonc]

Moving to Misc. Q.s until the OP responds with environment/tools information.