SQL query to get duplicate entry

[hoojx]

Is there a way for me to get duplicate entries in a table ?
eg.

[FONT=courier new]
id | username | email
1 user1 [e-mail]
2 user2 [e-mail]
3 user3 [e-mail]
[/FONT]

so I want to fetch row 2 & 3 (which contain duplicate email address)

Thanks.

[Sxooter]

select * from table a, table b where a.username=b.username AND a.email=b.email AND a.id!=b.id

should do it.