Ticker

6/recent/ticker-posts

Delete Duplicate Items in SQL

Delete LU
FROM   (SELECT *,
               Row_number()
                 OVER (
                   partition BY Document_Id
                   ORDER BY Document_Id DESC) [Row]
        FROM   Master_Scan_Stat_Report_AP) LU
WHERE  [row] > 1 

Post a Comment

0 Comments

Ad Code

Responsive Advertisement