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
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
0 Comments