SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily (@sqldaily) 's Twitter Profile Photo
SQL Daily
@sqldaily

3 months ago

Want to remove duplicate rows using Oracle #SQL? Use: DELETE ... WHERE ROWID NOT IN ( SELECT MIN ( ROWID ) FROM ... GROUP BY co1, col2, ... ) List the columns with duplicates in the GROUP BY clause This keeps one row for each set of values in this list and removes extras