DELETE FROM [Waqf_User_Registration]
WHERE Code NOT IN(
SELECT MAX(Code) AS MaxRecordID
FROM [Waqf_User_Registration]
GROUP BY [UserId]
);
-
Delete Duplicate Data in Sql server query syntex
(
SELECT MAX(Code) AS MaxRecordID
FROM [Waqf_User_Registration]
GROUP BY [UserId]
);
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment