Answer Posted / akki julak

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

Why is pl sql needed?

517

---

How does a self join work?

522

---

Can there be 2 primary keys in a table?

559

---

Can a table contain multiple primary key’s?

631

---

What is db journal file?

523

---

---

What is nvarchar max in sql?

584

---

how to create a new table in mysql? : Sql dba

554

---

what are the differences among rownum, rank and dense_rank? : Sql dba

542

---

what is the difference between a local and a global temporary table? : Sql dba

558

---

what are all different types of collation sensitivity? : Sql dba

527

---

How do you delete a table?

540

---

What is normalization in a database?

614

---

What is the purpose of using pl/sql?

667

---

define sql update statement ? : Sql dba

584

---

What are data types in pl sql?

566

---