Logo F2FInterview

Oracle Data Access Interview Questions

Q   |   QA
‹‹ previousnext ››

Use this SQL query :delete from student_tab A where ROWID > ( select min(ROWID) from student_tab B where A.roll_number = B.roll_number);Note : Table Name = student_tab Key to table = roll_number
Yes ,, we can delete entries from a table based on the date column,,Only we have to mention the date format or other wise we'll have to make use of the sys date.

‹‹ previousnext ››

In order to link this F2FInterview's page as Reference on your website or Blog, click on below text area and pres (CTRL-C) to copy the code in clipboard or right click then copy the following lines after that paste into your website or Blog.

Get Reference Link To This Page: (copy below code by (CTRL-C) and paste into your website or Blog)
HTML Rendering of above code: