Answer / vamsi

for example our emp table have duplicate rows than we can
run this query to delete those duplicate rows

Delete from emp a
where rowid <> ( select max(rowid) from emp where empno =
a.empno);

Answer / lova raju allumalla

delete from emp where rowid not in (select min(rowid) from
emp group by empno);

Answer / karthik

with [dup_cte] as {
select row_number(partition by eid order by eid) as rn from emp}
go
delete from [dup_cte] where rn>1

IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,

---

Difference between table function and pipelined function?

0 Answers  

---

What is the order of sql select?

0 Answers  

---

What is hibernate and its relation to sql?

0 Answers  

---

Explain what is sql*plus?

0 Answers  

---

What are the types of variable use in pl sql?

0 Answers  

---

What is sql query limit?

0 Answers  

---

Explain the update statement in sql

0 Answers  

---

Table Student has 3 columns,Student_id,Student_Name & Course_Id. Table Course has 2 columns, Course_Id & Course_Name.Write a query to listdown all the Courses and number of student in each course.

10 Answers   TCS,

---

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

---

please explain database architecture..

1 Answers   Infosys,

---

Is sql an operating system?

0 Answers  

---