Take a look at <a href="http://itknowledgeexchange.techtarget.com/itanswers/to-delete-the-duplicate-record-from-table-plz-provide-command/">this similar question</a>.
Also, you asked almost the same question in 2008. <a href="http://itknowledgeexchange.techtarget.com/itanswers/how-i-will-find-the-duplicate-rows-count-from-employee-table-in-oracle9i/">Here is the link to your first question</a>.
You can use the search feature of the site as well.
Last Wiki Answer Submitted: February 23, 2010 2:18 pm by carlosdl63,535 pts.