how to delete all duplicate records from a table using
subquery?
Answer Posted / dharmendra
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 |
Post New Answer View All Answers
What is an oracle database?
Explain what are synonyms used for?
What is the usage of merge statement?
What is meant by joins?
How much memory your 10g xe server is using?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
why should i declare foreign key constraint as self relation instead of binary relation in tables ?
What to do if the binary spfile is wrong for the default instance?
How to bring a tablespace offline?
What is catalog in Oracle?
What are joins, explain all types of joins?
Explain view?
What is an oracle user role?
What do you mean by group by clause?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?