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

What is interval partition?

0 Answers  

---

hi..........i m Accenture employee...Accenture is an IT company having itz branches in India at Mumbai, Pune,Delhi, Hyderabad, Chennai and Bangalore....Presently there are openings here for SAP, Testing, Oracle,Java,.NET,MAinframe and Peoplesoft...... I am a software engineer working with Accenture,Mumbai....u can mail me in your resume..i`ll forward it to our HR team...my mail id: pankit.lodaya@accenture.com

8 Answers   Wipro,

---

If records are inserted into table without committing.How to refer to these values in a procedure?

2 Answers  

---

How do I trace sql profiler?

0 Answers  

---

Explain dml and ddl?

0 Answers  

---

What is dbo in sql?

0 Answers  

---

What are sql ddl commands?

0 Answers  

---

what is the difference between where clause and having clause? : Sql dba

0 Answers  

---

how do you tune the slow running queries in oracle db , explain the methodology

0 Answers  

---

What is the difference between python and sql?

0 Answers  

---

What is union, minus and interact commands?

0 Answers  

---

What is sqlite format?

0 Answers  

---