Help with query

[suluclac]

Suppose I have the following table:

TABLE_NAME
ID
TEAM_NAME
LEAGUE_NAME
DIVISION_NAME
RECORD

I need the result of my query to return only those records that share the same TEAM_NAME.

Still a noob with all this, so any help would be great!

[skhanal]

select * from table1
where team_name in (select team_name from table1 group by team_name having count(*)>1)

[suluclac]

Thank you!