Row comparison in Database

Question

Hai all.....

I have a small doubt..I want to fetch a single row from the database and compare it with all other rows in the database whether they are equal or not.if equal simply i want to delete the row.......

and can i also fetch a complete row as a single object?

if yes how am i go about this.......