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 |
What are tuples in sql?
what is heap table? : Sql dba
What are the advantages of stored procedure?
Where do we use pl sql?
Which are the different types of indexes in sql?
What is dynamic SQl and how you will create and execute dynamic sql?
What is cross join example?
Are sql database names case sensitive?
How to return multiple records from procedure?
Difference between views and materialized views?
What is materialized view in sql?
What are Lexical Parameters.How They are used in Reports 6i