Answer Posted / 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

how many sql dml commands are supported by 'mysql'? : Sql dba

1128

---

what are the authentication modes in sql server? How can it be changed? : Sql dba

1441

---

How do I trace sql profiler?

992

---

What is a database event trigger?

1165

---

Are sql connections encrypted?

1034

---

how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

1014

---

What is transaction control language (tcl)?

1142

---

who introduced sql?

1026

---

what is the difference between clustered and non clustered index in sql? : Sql dba

1132

---

How do I run a sql trace?

964

---

What are the differences between in and exists clause?

1115

---

What is a schema? How is it useful in sql servers?

1125

---

what are the different tables present in mysql, which type of table is generated when we are creating a table in the following syntax: create table employee (eno int(2),ename varchar(10)) ? : Sql dba

1041

---

How can you save or place your msg in a table?

1004

---

What is the purpose of my sql?

955

---