DELETE TABLE_NAME WHERE ROWID NOT IN (SELECT MIN(ROWID) FROM TABLE_NAME GROUP BY COLUMNS)
Tutorial for Denodo,OBIEE 11g, SQL, PLSQL, Datawarehousing beginners.
Deleting Duplicate Records in SQL
DELETE TABLE_NAME WHERE
ROWID NOT IN (SELECT MIN(ROWID) FROM TABLE_NAME GROUP BY COLUMNS)
Subscribe to:
Posts (Atom)
Featured post
Snowflake - Creating warehouse in Snowflake
Creating warehouse Login to Snowflake and click on warehouse and click on Create fill the necessary details and click Finish We can also c...
-
We can use call NQS_GetAllCacheEntries(); command to get all the cache entries available in server. steps to use: 1. Login to analytics as... -
We can use call NQS_GetAllCacheEntries(); command to get all the cache entries available in server. steps to use: 1. Login to analyt...
-
Variable Description USER Holds the value the user enters as his or her logon name. Thi...