Eliminate duplicate values in a table

In SQL server, the "PARTITION BY" clause is utilized to divide a result set into partitions depending on the values of one or more columns. This feature can be employed to eliminate duplicate values in a table.

WITH CTE AS
(
SELECT *,ROW_NUMBER() OVER (PARTITION BY Column_Name ORDER BY Column_Name ) AS RN
FROM Table_Name
)

DELETE FROM CTE WHERE RN<>1

Top comments (0)

Empowering Dreams: A Day of Joy and Learning

Bhuvaneswari Subramani - Dec 20

Mastering Docker Volumes: Best Practices for Persistent Data Management in Containers

Abhay Singh Kathayat - Dec 20

Building an Event-Driven Architecture for Content Embedding Generation with AWS Bedrock, DynamoDb, and AWS Batch

Salam Shaik - Dec 20

Getting Started with Docker Compose: A Guide to Simplifying Multi-Container Applications