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 the use of non clustered index?

0 Answers  

---

What are user defined stored procedures ?

3 Answers   BirlaSoft,

---

Why we use joins in sql?

0 Answers  

---

Is vs as in pl sql?

0 Answers  

---

Why is stored procedure faster than query?

0 Answers  

---

what tools available for managing mysql server? : Sql dba

0 Answers  

---

What are the pre requisites?

1 Answers  

---

How to use distinct and count in sql query? Explain

0 Answers  

---

What is break?

0 Answers  

---

The in operator may be used if you know the exact value you want to return for at least one of the columns.

0 Answers  

---

How do you write an inner join query?

0 Answers  

---

What is Overloading of procedures ?

2 Answers  

---