Here I am using CTE(Common Table Expression) for Delete duplicate rows.
PARTITION BY : It devides the query result into partitions
Row_NUMBER : gives unique name for all duplicate rows ie., if one row record repeated for 3 times . it gives the index such as 1,2 and 3
Using this query we can delete all duplicate rows in a table
With EmployeeCTE AS
(
Select *, ROW_NUMBER() Over (Partition BY ID order by ID)as RowIndex
from tbl_Employees)
--- Here we are going to delete all duplicate records except one record(original)
Delete from EmployeeCTE Where RowIndex > 1
Post your comments / questions
Recent Article
- How to Enable Virtualization in BIOS Security Settings in Intel Processors For Android Studio?
- Dependency 'androidx.activity:activity:1.8.0' requires libraries and applications that depend on it.
- AttributeError: 'NoneType' object has no attribute 'get_text' - Python
- ModuleNotFoundError: No module named 'openpyxl' - Python
- How to get thumbnail from vimeo video URL in Python?
- Remove all special characters, punctuation except spaces from string - Python
- OSError: cannot write mode RGBA as JPEG- Python
- expected str, bytes or os.PathLike object, not JpegImageFile - Python
Related Article