SELECT MAX( salary) FROM salary where salary not in( SELECT DISTINCT TOP 3

how to find nth highest salary

Question Posted / shiva

Answer Posted / shiva

SELECT MAX( salary) FROM salary where salary not in(
SELECT DISTINCT TOP 3 salary FROM salary order by salary desc)

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

explain extended properties

926

Explain how many types of relationship?

971

Explain transaction isolation levels in sql server?

1034

Difference between Inner vs outer joins?

893

What is database black box testing?

983

How can you insert null values in a column while inserting the data?

1209

hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail

2154

What is the Disadvantage of indexed sequential file.

1026

How do I shrink an ldf file?

931

How to create nested stored procedure?

946

Can we write trigger for view?

947

What is the difference between Normalization and De-normalization?

1028

Explain about system database?

998

Create and insert into temp table in sql server?

974

What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?

938