Answer Posted / ahamed

The following solution is for getting 6th highest salary
from Employee table ,
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP 6 salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary

or

SELECT MIN(Sal) FROM TableName
WHERE Sal IN
(SELECT TOP 6 Sal FROM TableName ORDER BY Sal DESC)


Reference:

http://blog.sqlauthority.com/2008/04/02/sql-server-find-nth-highest-salary-of-employee-query-to-retrieve-the-nth-maximum-value/

What is foreign key sql?

987

---

Is oracle sql free?

988

---

what are the differences between require and include, include_once and require_once? : Sql dba

1022

---

explain normalization concept? : Sql dba

1048

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1077

---

What are sql commands?

1014

---

How do I run sql profiler?

1072

---

Is ms sql traffic encrypted?

925

---

How do I run a sql query in pgadmin 4?

961

---

what is row? : Sql dba

1228

---

What is dbo in sql?

962

---

What is a table partition?

1133

---

how to select unique records from a table? : Sql dba

1113

---

Why query optimization is needed?

930

---

How many types of cursors are available in pl/sql?

1109

---