Answer Posted / vishal beri

Select ename from emp e where 2=(select count(distinct(Sal))
from emp where sal>e.sal)

Is delete faster than truncate?

550

---

How many disk partitions should I have?

553

---

Why plvtab is considered as the easiest way to access the pl/sql table?

621

---

What is the meaning of disabling a trigger?

647

---

how many columns can be used for creating index? : Sql dba

522

---

---

Do prepared statements prevent sql injection?

532

---

What are all types of user defined functions?

532

---

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

523

---

What is sap sql?

536

---

What trigger means?

567

---

What is a column in a table?

558

---

What is sharding in sql?

566

---

What is the order of sql select?

572

---

What is where clause in sql?

537

---

What is sql select statement?

505

---