Delete Duplicate Data in Sql server query syntex

 DELETE FROM [Waqf_User_Registration]

    WHERE Code NOT IN
    (
        SELECT MAX(Code) AS MaxRecordID
        FROM [Waqf_User_Registration]
        GROUP BY [UserId]
    );