Viewing 2 posts - 1 through 2 (of 2 total)
select id,name from tablename
where id in (select id from tablename group by id having count(id)>1)
OR
select id,name from tablename group by
id having count(id) > 1
OR (For ALL columns Contains Same Values...
July 18, 2008 at 4:30 am
#844893
July 18, 2008 at 4:29 am
#844890