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 difference between delete and truncate commands?
What is the purpose of normalization?
What are analytical functions in sql?
Does google use sql?
Why select is used in sql?
what command is used to create a table by copying the structure of another table including constraints ?
What are the advantages of the packages
what are tables and fields? : Sql dba
I have following column in the table. col1 1 a b c 2 3 d and I want to display it as num chars 1 a 2 b 3 c 4 d numbers in one column and letters in another column.
How do I edit a trigger in sql developer?
What are the different type of joins in sql?
Which are the different case manipulation functions in sql?