Delete duplicate records from Table in SQL Server
Автор: Laksh
Загружено: 2026-01-01
Просмотров: 14
Delete duplicate records from Table in SQL Server #sql #dataengineering
CREATE TABLE DEmployees (
EmpID INT,
EmpName VARCHAR(50),
Department VARCHAR(20),
Salary INT
);
INSERT INTO DEmployees VALUES
(1, 'Amit', 'IT', 60000),
(2, 'Amit', 'IT', 60000),
(3, 'Ravi', 'HR', 50000),
(4, 'Ravi', 'HR', 50000),
(5, 'Neha', 'IT', 70000);
Select * from DEmployees;
WITH CTE AS
(
Select * ,ROW_NUMBER() over(partition by EmpName,Department,Salary order by Salary) as RN
from DEmployees
)
Delete from CTE where RN=2
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке: