Wednesday, 24 October 2012

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