Duplicate values

[micmac]

Hello All,

I have a database with columns like id, date_time, name, url, etc.

If a particular field, lets say the url field has a duplicate value how do i write an SQL query to select these rows.

Any suggestions would be most appreciated!

Cheers,
micmac

[Lars_Berg]

select * from t
where url in
(select url 
   from t
  group by url
  having count(*) > 1 )