while using rownum in DML statement '>' is invalid, u have to use only '<' less than operator
Only this SQL query works
Delete from mytable where rownum < 2 then row with rownum = 1 is getting deleted
|
Results 1 to 8 of 8
Thread: Duplicate RowsThreaded View
|
Click Here to Expand Forum to Full Width |