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);
Posted by Unknown at 19:02
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ▼  2012 (17)
    • ►  November (1)
    • ►  September (1)
    • ►  August (7)
    • ▼  July (8)
      • To Calculate total Useable Disk Space with differe...
      • Drop/Create Oracle Enterprise Manager
      • Script to count specific string in whole statement
      • Scipt to list files names at server directory
      • script to get sessions that consume undo
      • Move indexes , tables and LOB segments from Tables...
      • Find Numeric and Non-Numeric Records
      • Get duplicated data in a table

Oracle Database administrator

Unknown
View my complete profile
Simple theme. Powered by Blogger.