Answer Posted / akki julak

select count(empno)-count(distinct(empno)) from emp;

What is difference between db2 and sql?

1046

---

what is meant by nl2br()? : Sql dba

1107

---

What are aggregate functions in sql?

1225

---

Who developed sql?

1100

---

Why partition by is used in sql?

1083

---

Explain unique key in sql.

1063

---

Is left join same as join?

1039

---

When sql appeared?

1148

---

how to delete an existing column in a table? : Sql dba

1062

---

what are the different type of sql's statements ? : Sql dba

980

---

what's the difference between a primary key and a unique key? : Sql dba

1112

---

How to disable a trigger name update_salary?

1316

---

Can you upgrade sql express to full sql?

1143

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1068

---

How can I delete duplicate rows?

1063

---