Answer / sivadasan

I think simply we can do like the following..

1. First we have to transfer all data from a table to
temporary table

create table Temp_table as select * from original_table;

2. Delete all record from Original Table....

delete original_table;

3. Now we can write a query by using INSERT and UNION

If any issue let me know....

insert into original_table (select * from temp_table
UNION select * from UNION )

Answer / umadevi

--deletes records within table without changing table name
delete from temp t1 where rowid<(select max(rowid) from temp
t2 where t1.empno=t2.empno) order by empno;

or
--create new table n insert records.
create table t1 as select distinct * from temp;

or
(truncate table)
truncate table t1;
insert into t1 select distinct * from temp;

Answer / swapna

One way is to rename the original table to something else,
and copy the unique records into the original table.

rename 'Table2', 'Table1'

select distinct * into Table2 from Table1

drop table1

What is thread join () in threading?

0 Answers  

---

What is difference between joins and union?

0 Answers  

---

what is query cache in mysql? : Sql dba

0 Answers  

---

What is PL/SQL table ?

6 Answers  

---

Why you are not able to create a table using select command,if it is having a LONG column? for eg:create table test as select * from test1 here test1 containg a column having LONG datatype...

1 Answers  

---

what is the difference between char and varchar data types? : Sql dba

0 Answers  

---

Can a table have two primary keys?

44 Answers   HCL, MetaCube,

---

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

0 Answers  

---

What is data abstraction in sql?

0 Answers  

---

Is oracel sql developer written in java?

0 Answers  

---

What is integrity in sql?

0 Answers  

---

What is row_number () in sql?

0 Answers  

---