Answer Posted / himanshu

Just replace the N with required number:


SELECT empid, empname, empsalary FROM emp e
WHERE (SELECT COUNT(DISTINCT(e2.empsalary))
FROM emp e2
WHERE e2.empsalary >=
e.empsalary ) = N

ex: 4th highest

SELECT empid, empname, empsalary FROM emp e
WHERE (SELECT COUNT(DISTINCT(e2.empsalary))
FROM emp e2
WHERE e2.empsalary >=
e.empsalary ) = 4

what is a schema in sql server 2005? : Sql server database administration

1034

---

What are the different types of collation sensitivity?

1129

---

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

953

---

What is sql stored procedure?

1099

---

How to create hyperlink from returned sql query ?

1128

---

What is sql server locking?

996

---

What is de-normalization in sql database administration? Give examples?

987

---

What is clustered index

1013

---

What command would you use to create an index?

1056

---

How to disable triggers using "disable trigger"?

1058

---

What do you understand by integration services in sql server?

965

---

What are dml triggers and types of dml triggers?

983

---

Explain boyce and codd normal form(bcnf)?

962

---

What are null values in ms sql server?

1095

---

What is difference between primary key and foreign key?

907

---