Answer Posted / bcaramu

delete from employee
where (empid, empssn)
not in
( select min(empid), empssn
from employee group by empssn);

Can we use pl sql in sql server?

1083

---

Is sql a scripting language?

1018

---

what are null values? : Sql dba

957

---

What is nvarchar max in sql?

1019

---

What is the difference between a database and a relational database?

1103

---

What is sql clause?

1052

---

Is left join faster than inner join?

1125

---

how to see the create table statement of an existing table? : Sql dba

1019

---

How do you rename a table in sql?

1113

---

Can we call a function containing dml statements in a select query?

980

---

How can you create an empty table from an existing table?

1080

---

How do I kill a query in postgresql?

1129

---

Is null operator in sql?

1041

---

Is left join inner or outer?

1015

---

Why use truncate instead of delete?

1017

---