LexaChebara/gist:6534766

Created September 12, 2013 09:04

Star (0) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Select an option

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/LexaChebara/6534766.js"></script>
Save LexaChebara/6534766 to your computer and use it in GitHub Desktop.

Download ZIP

Quick removing of duplicate rows in Oracle table T over X, where X can be set of columns.

Raw

gistfile1.sql

	DELETE FROM T WHERE ROWID IN (
	SELECT rid
	FROM (SELECT ROWID rid, ROW_NUMBER() OVER ( PARTITION BY X ORDER BY ROWID ) rn FROM T)
	WHERE rn > 1);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment