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.