Forum Discussion
Solved
Unexpected Duplicates in SQL Query
Hello everyone, Could someone please explain why I'm getting duplicate values even though my query is supposed to prevent them? And if possible, suggest a solution to fix it. Best regards, Or...
Hi Ornella ,
Thank you for reaching out to Microsoft Fabric Community Forum.
burakkaragoz lutz_bendlin Thank you for your quick response.
Could you please try the below SQL query:
WITH CTE AS (
SELECT *,
ROW_NUMBER() OVER (PARTITION BY CAST(DATE_EXEC AS DATE) ORDER BY DATE_EXEC DESC) AS rn
FROM XXXX_CTRL_CARD
WHERE CAST(DATE_EXEC AS DATE) = CAST(GETDATE() AS DATE)
)
DELETE FROM CTE WHERE rn > 1;
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Isn't your query equivalent to
DELETE FROM XXXX_CTRL_CARD
WHERE CAST(DATE_EXEC as DATE) <= GETDATE()
?