how to delete all duplicate records from a table using
subquery?
Answer Posted / sunil
delete emp where empno not in(select distinct empno from emp);
For example we have duplicates in empno column then write
query like above...whatever column u want u can write..
Is This Answer Correct ? | 0 Yes | 11 No |
Post New Answer View All Answers
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
When system tablespace is created?
Which environment variables are absolutely critical in order to run the OUI?
Explain coalesce function?
What is data file?
What is coalesce function?
What happens to indexes if you drop a table?
How to start your 10g xe server?
What are internal user account in oracle?
What are the different oracle database objects?
can u plz provide me oca sql dumps please i need them
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
How data locks are respected in oracle?
What language does oracle use?
Can we protect our pl/sql source code?