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 are types of subqueries?

1069

---

How to skip remaining statements in a loop block using continue statements?

999

---

Do you know hot add cpu in sql server 2008?

955

---

What is a View ? Can we insert, Update and delete a view?

995

---

Do you know what are pages and extents? : SQL Server Architecture

995

---

What is the difference between value type and reference type?

922

---

What is dbcc command in sql server?

1094

---

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1008

---

If no size is defined while creating the database, what size will the database have?

992

---

How many null values we can have in a unique key field in sql server?

958

---

What do you mean by collation recursive stored procedure?

1056

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

952

---

What are functions in the sql server?

1221

---

Explain what are the database objects? : SQL Server Architecture

1084

---

What is the importance of concurrency control?

1230

---