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 triggers and its uses?

1 Answers  

---

What is audit logout in sql profiler?

1 Answers  

---

What is sqlservr exe?

1 Answers  

---

table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

What is the difference between drop and truncate commands?

1 Answers  

---

Are views faster than queries?

1 Answers  

---

What are all the different normalization?

1 Answers  

---

Explain isolation levels. : Transact sql

1 Answers  

---

How can I see all tables in sql?

1 Answers  

---

how to rename an existing table in mysql? : Sql dba

1 Answers  

---

Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  

---

What is string join?

1 Answers  

---