Answer Posted / saravanan

The below 2 queries will work
n - The nth highest salary

First query
------------------------
SELECT MAX(salary)
FROM
(SELECT salary
FROM emp
WHERE salary IS NOT NULL
ORDER BY salary DESC)
WHERE rownum < &n;

Second query
------------------------
SELECT DISTINCT(a.salary)
FROM emp a
WHERE &n =
(SELECT COUNT(DISTINCT(b.salary))
FROM emp b
WHERE a.salary <= b.salary)
;

What do you understand by check constraint in sql server?

889

---

How to create a local temporary stored procedure?

949

---

Can you force a query to use a specific index?

889

---

How to compose an inquiry to demonstrate the points of interest of an understudy from students table whose name begins with k?

1046

---

how we use window authentication connection with sql server.?

1087

---

What is the usage of sign function?

1040

---

Explain system scalar functions?

955

---

what are the different stages of Report Processing?

125

---

What are indexes in sql?

1177

---

What is an execution plan? When would you use it?

921

---

How do I manually uninstall an instance of sql server 2016?

965

---

How you can get a list of all the table constraints in a database? : Sql server administration

951

---

Explain differentiate between a having clause and a where clause?

854

---

What is a virtual table in sql?

944

---

State a few properties of relational databases?

1062

---