Hi

Try this


Select * from table_name
where name in (select name
from table_name
group by name
having count(name) >= 2)


Thanks
P Soni

[Edited by PSoni on 06-12-2001 at 08:26 AM]