Answer Posted / 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;

Which sql statement is used to delete data from a database?

952

---

What is rank function in sql?

1016

---

what is the difference between blob and text? : Sql dba

1006

---

Why do we need a foreign key?

1086

---

What are the basic techniques of indexing?

1057

---

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1031

---

What is the difference between rename and alias?

1333

---

what is a materialized view? : Sql dba

1055

---

what is dbms? : Sql dba

983

---

what are the nonstandard string types? : Sql dba

1130

---

what is csv? : Sql dba

990

---

How many types of cursors are available in pl/sql?

1098

---

what is auto increment? : Sql dba

1000

---

What is secondary key?

927

---

What is rownum and rowid?

1025

---