gipasoft

DELETE duplicate row

Jun 21st, 2023
1,333
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.22 KB | None | 0 0
  1. USE FAD_Planning
  2.  
  3. DELETE T
  4. FROM
  5. (
  6.     SELECT *
  7.     , DupRank = ROW_NUMBER() OVER (
  8.                   PARTITION BY IdCourseEvent, IdUser, LessonCode, Text
  9.                   ORDER BY (SELECT NULL)
  10.                 )
  11.     FROM Comments
  12. ) AS T
  13. WHERE DupRank > 1
Advertisement
Add Comment
Please, Sign In to add comment