Answers

Question and Answer:

  Home  Oracle Data Access

⟩ Explain Can we delete tuples in a table based on date column? And how?

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.

 172 views

More Questions for you: