Delete All But Last Record 1 to Many Table

suggest change
WITH cte AS (
  SELECT ProjectID,
         ROW_NUMBER() OVER (PARTITION BY ProjectID ORDER BY InsertDate DESC) AS rn
  FROM ProjectNotes
)
DELETE FROM cte WHERE rn > 1;

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:


Row number:
*Delete All But Last Record 1 to Many Table

Table Of Contents