Finding duplicate records

[kschuster]

Would the sql look like to find duplicate values in a column. I need to find duplicate email addresses in a mysql table

thanks

[Lars_Berg]

select email from t
group by email
having count(*) > 1