Hi,

Please let me know how to FETCH (not delete) duplicate records from a table.

Eg:

If a table has records like
Col1 Col2 Col3
1 a asdfs
2 b asgfged
3 c gsdgds
1 a asdfs

when the SQL query is executed, the result should be
Col1 Col2 Col3
1 a asdfs
1 a asdfs