Oracle DBA
Saturday, 21 July 2012
Get duplicated data in a table
select * FROM scott.employees
WHERE ROWID NOT IN
(SELECT MIN(ROWID) FROM
scott.employees
GROUP BY first_name,last_name);
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment