Answer Posted / abhishek jaiswal

select salary from employees a where &nth_highest_salary =(select count(distinct salary)
from employees b where a.salary<=b.salary)
/

What are the different set operators available in sql?

1024

---

What is difference between left and right outer join?

983

---

What is integrity in sql?

1041

---

What are the different ways to optimize a sql query?

946

---

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1058

---

How to add new employee details in an employee_details table with the following details

1089

---

Explain some predefined exceptions.

1031

---

What are the packages in pl sql?

1009

---

What is the use of & in pl sql?

1045

---

What is difference between procedure and trigger?

978

---

How to Execute a Package in PL/SQL.?

1200

---

What is the difference between a subquery and a join?

1101

---

What is the difference between sql and t sql?

1031

---

How do I audit the sql sent to the server?

1004

---

How does cross join work in sql?

1014

---