insert update select

Technical Article

RE: DELETE DUPLICATE ROWS

  • Reply

Thanks Jay it worked with the double FROM WTRDET statement. Its strange though while i was testing SQL with the same SELECT * query it gave me an error. But worked fine with the DELETE STATEMENT. Thanks once again for your time and help.

You rated this post out of 5. Change rating

2003-06-05

Blogs

Our Contributions Towards a Stronger Open Source Future

By

Whether you’re a developer at an agency or an aspiring creator, you can trust...

Rebuilding a SQL Server Database Transaction Log

By

“Could you help me, we deleted the database’s transaction log file and now that...

Copying Content from One Databricks Unity Catalog Catalog to Another

By

I had a couple of clients who were moving content from development catalogs to...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers