Tuesday, May 24, 2011

FIND DUPLICATE ROW

-- find duplicate row

select ID from SCOTT.DET
group by id having count(id)>1

No comments:

Post a Comment