WITH CTE AS (
SELECT ProductId,
-- Add other columns as needed
ROW_NUMBER() OVER (PARTITION BY ProductId ORDER BY (SELECT NULL)) AS RowNumber
FROM Master.VehicleType
)
DELETE FROM CTE WHERE RowNumber > 1;
Subscribe to:
Post Comments (Atom)
-
Points 1.complex page layouts and adherence to code standards. 2.primeNG pagination 3.ngcontent 4.ngdestory(memorylekage) 5.datatransfer wi...
-
Check duplicate count based on 3 columns combo select EMPID,FORMinfoID,FormName,Count(*) as counts from tbl_FilesMigrationLogs group by Em...
No comments:
Post a Comment