hi
How to Delete Duplicate Record Match StudentId,ClassId 2 fields
Create Table TestNameList
(
StudentId int,
StudName varchar(50),
ClassId int
)
Insert into TestNameList values(1,'John',1)
Insert into TestNameList values(2,'John',2)
Insert into TestNameList values(1,'John',1)
Insert into TestNameList values(2,'John',3)
Insert into TestNameList values(3,'John',3)
Insert into TestNameList values(3,'Joshn',3)
Here I need How to find Duplicate Record match StudentId and ClassId Allow 1 Records then
Duplicate Record need to Delete
Mark as Answer if its helpful to you
Kumaraspcode2009@gmail.com