what eliminate duplicate without using roenum and not
Answers were Sorted based on User's Feedback
Answer / madhav
DELETE FROM emp1 A WHERE ROWID > (SELECT min(rowid)
FROM emp1 B
WHERE A.empno = B.empno);
---conn scott/tiger@orcl
create table emp1 as select*from emp;
14 rows inserted
SQL> select*from emp1;
14 rows selected
-----------
insert into emp1
selectempno,ename,job,mgr,hiredate,sal,comm,deptno from emp;
14 row inserted
select*from emp1;
28 rows slected --(14 duplicates row are there)
you can use starting query duplicates rows deleted
Email:thota.madhav@gmail.com
Is This Answer Correct ? | 11 Yes | 0 No |
Answer / satyajit patel
Mr. Kondla is almost right, but forgotten to use keyword
DISTINCT. It should be like
-> create table T2 as select DISTINT(*) from T1;
-> drop table T1;
-> rename T2 to T1;
Is This Answer Correct ? | 3 Yes | 1 No |
Answer / gourav
we can use distinct keyword for elaminate duplicat rows
select distinct(salary)from emplpyees
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / amar_kondla
>create table table_name2 as select * from table_name1;
>drop table table_name1;
> rename tabale_name2 to table_name1;
Is This Answer Correct ? | 1 Yes | 4 No |
Explain mutating table error.
What is the maximum number of triggers,can apply to a single table?
Does sql backup shrink transaction log?
what is the differnce between procedure and function? in both dml operations can work and in procedure through out parameter you can return value ,then what is the differce?
How do I copy a table in sql?
Give an example of any procedure.
5 Answers Accenture, iFlex, Wipro,
Is natural join same as inner join?
what is a trigger in mysql? : Sql dba
Are left and right joins the same?
What is sqlite used for?
What is crud sql?
what are the differences among rownum, rank and dense_rank? : Sql dba