Sunday, 18 February 2024

delete duplicate records based on the Id

 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;

at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

best

  The phrase "Everything should be made as simple as possible, but not simpler" is a quote by Albert Einstein, meaning that  while...

  • wrap text in excel
     if text length big make it next line shorcut is ALt+Enter or cilck on wrap text
  • interview Harsco(enviri)
     Points 1.complex page layouts and adherence to code standards. 2.primeNG pagination 3.ngcontent 4.ngdestory(memorylekage) 5.datatransfer wi...
  • Dtabase design
      OLX, like many large-scale online platforms, employs a variety of data structures and technologies to manage its data effectively. While s...