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.
Subscribe to:
Post Comments (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...
-
Follow the steps below and ensure that you receive no error messages. These steps are also very general to setting up privileges for...
Incorporate in Wyoming! Wyoming is the most preferred one-stop destination for start-up businesses as well as big corporations. Incorporate in Wyoming Online
ReplyDeletePretty blog, so many ideas in a single site, thanks for the informative article, keep updating more article.
ReplyDeletesoftware testing course in Chennai
Thanks For Your valuable posting. Pridesys Business Intelligence (BI) is offering you easy-to-use analytics and business intelligence tools. With these tools you can explore your data. Create new patterns, rich visual and insights.for more info: Pridesys IT Ltd
ReplyDeleteNice post.Thanks for sharing this post. Pridesys Business Intelligence (BI) is offering you easy-to-use analytics and business intelligence tools. With these tools you can explore your data. Create new patterns, rich visual and insights. to know more information visit: Pridesys IT Ltd
ReplyDelete