PHP MySQL help

[Elctroshk3]

im trying to figure out this code and its bugging me. Can you please help me?

2. Write a SQL statement to return the emails that show up more than once in a table with the following schema?

Table name: Users
Email Varchar(100)
City Varchar(100)
State Char(2)

if you can please help me out that would be great! thanks

[Rodney_H_]

school assignment??

[zzlong]

You'll need "group by" and "having" clauses. Check MySQL Manual for details of SELECT statement.

select email, count(email) from users group by email having count(email) > 1