select top 1 salary from emp where (salary<(select max (salary) from em

how to find nth highest salary

Question Posted / smitam

Answer Posted / smitam

select top 1 salary from emp where (salary<(select max
(salary) from emp ))ORDER BY salary DESC

Is This Answer Correct ?

9 Yes

21 No

Please Help Members By Posting Answers For Below Questions

Explain what is public role in sql server?

1135

What is perspective, have you ever created perspective? : sql server analysis services, ssas

917

Difference between aggregate functions of sql?

1106

What are security principals used in sql server 2005?

988

Do you know what are the restrictions that views have to follow?

1079

What are a database and a data warehouse?

1022

How to recreate an existing index in ms sql server?

1057

What do you understand by the denormalisation?

959

Does partitioning help performance?

937

What is the difference between count () and rowcount ()?

1028

What is an index in sql?

1006

What is the difference between ddl and dml?

1048

How many servers can we create in a single subscription?

162

How do I view views in sql server?

1010

Why we need to use secondry database file? though, we can do same work using primary database file also.

6890