delete from BOARD.BOARD_RESULT_DATA
where rowid IN ( select rid
from (select rowid rid,
row_number() over (partition by
ROLL_NO, REGNO, PASS_YEAR, BOARD_NAME
order by rowid) rn
from BOARD.BOARD_RESULT_DATA)
where rn <> 1);
where rowid IN ( select rid
from (select rowid rid,
row_number() over (partition by
ROLL_NO, REGNO, PASS_YEAR, BOARD_NAME
order by rowid) rn
from BOARD.BOARD_RESULT_DATA)
where rn <> 1);
No comments:
Post a Comment