--CREATE TABLE--
CREATE table nagu
(
rno varchar(10),
rname varchar(30)
)
--SELECT QUERY---
SELECT *FROM NAGU
--ROW NUMBER --
SELECT row_number()OVER(PARTITION BY rno ORDER BY rno)as SRNO,RNO,RNAME
from nagu
--DUPLICATE RECORD DELETE--
WITH numbered
AS ( SELECT row_number() OVER ( PARTITION BY RNO ORDER BY RNO ) AS SRNO,RNO, RNAME
FROM NAGU
)
DELETE FROM numbered
WHERE SRNO > 1
--SELECT Query--
SELECT *FROM NAGU
No comments:
Post a Comment