TATA Consultancy Services Interview Question
Country: -
To find Duplicate entries in Oracle Database
select name,count(name) from student group by name having count(name)>1
To delete duplicate entries from Database
delete from student where rowid not in(select min(rowid) from student group by name)
- sumit chauhan September 27, 2011