Answer Posted / lalit dwivedi

select a.salary
from emp a
where 3=(select count(distinct(b.salary))
from emp b
where a.salary<=b.salary)

What is the difference between syntax error and runtime error?

1069

---

What are the types of dbms?

922

---

In pl/sql, what is bulk binding, and when/how would it help performance?

938

---

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

1132

---

Is a foreign key always unique?

884

---

What is indexes?

1002

---

Does truncate remove indexes?

971

---

Why function is used in sql?

880

---

What is a native sql query?

977

---

What is a sql statement?

903

---

What is user defined functions?

918

---

what is unique key constraint? : Sql dba

993

---

When can we use the where clause and the having clause?

968

---

How to raise user-defined exception with custom sqlerrm ?

1063

---

What are pl/sql packages?

1035

---