sql: 查找重复列值的行

select *  from tablename a 
where(
	select count(*) 
	from tablename
	where url = a.url
) > 1;