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 are the constraints available in sql?

0 Answers  

---

How will you select unique values from a list of records?

7 Answers   Cap Gemini,

---

How many triggers can be implemented for a table?

3 Answers   HSBC,

---

What is compound trigger?

0 Answers  

---

What is a primary key called that is made up of more than one field?

0 Answers  

---

how to decrement dates by 1 in mysql? : Sql dba

0 Answers  

---

How does a covering index work?

0 Answers  

---

What is a constraint? Tell me about its various levels.

0 Answers  

---

What is the purpose of the sql select top clause?

0 Answers  

---

is mysql query is case sensitive? : Sql dba

0 Answers  

---

What are the advantages of VIEW?

5 Answers  

---

what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure

0 Answers  

---