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 is the use of non clustered index?
Is truncate ddl or dml?
How can you load multi line records? : aql loader
How to select 10 records from a table?
What is sql select statement?
Define implicit and explicit cursors.
Explain the order of sql statement execution?
Can we call a function containing dml statements in a select query?
What is field delimiter?
What are joins in sql?
What are sql queries used for?
Why triggers are used?