dharmendra.r


{ City } chennai
< Country > india
* Profession * software engineer
User No # 22896
Total Questions Posted # 0
Total Answers Posted # 1

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 12
Users Marked my Answers as Wrong # 5
Questions / { dharmendra.r }
Questions Answers Category Views Company eMail




Answers / { dharmendra.r }

Question { ABC, 21944 }

how to delete all duplicate records from a table using
subquery?


Answer

delete from emp e1 where rowid >(select min(rowid) from emp
e2 where e1.empid=e2.empid)

Is This Answer Correct ?    12 Yes 5 No