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...
Pretty 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