Select salary from employees order by salary desc limit n-1,1;

how to find nth highest salary

Question Posted / amit

Answer Posted / amit

Select salary
from employees
order by salary desc
limit n-1,1;

Is This Answer Correct ?

2 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain about Normalization?

1122

What is the downside of using udf?

1162

What is normalization according to you and explain its different levels?

996

How to create user defined functions with parameters?

1298

Explain the functionalities that views support?

1162

What is bit data type? What's the information that can be stored inside a bit column?

969

What is the difference between a stored procedure and a user defined function?

1067

How many database files are there in sql server 2000?what are they?

1111

How to attach adventureworkslt physical files to the server?

1160

What is the sql case statement used for?

1133

How many types of triggers in sql server?

1094

What happens if null values are involved in bitwise operations?

1081

Is it possible to update the views? If yes, how, if not, why?

1089

What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?

940

What is instead of trigger sql server?

1081