to get nth higest value SELECT EMP_NAME,EMP_SALARY FROM EMP

how to find the n'th highest salary from emp ?

Question Posted / madhu

Answer Posted / madhu

to get nth higest value

SELECT EMP_NAME,EMP_SALARY
FROM EMP_TABLE
ORDER BY EMP_SALARY DESC
LIMIT n-1, 1

this is for mysql server

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to assign values to data fields in record variables?

1077

How to specify default values in insert statement using oracle?

1153

What is the difference between translate and replace?

1118

What is max rowid in oracle?

1081

How different is ms access and oracle?

1089

What do you understand by a database object? Can you list a few of them?

1064

How to pass parameters to procedures in oracle?

1082

What are the execution control statements in oracle?

1131

What is bulk collect in oracle?

1053

How can windows applications connect to oracle servers?

1115

Which are the five query types available in oracle?

1000

Explain self joins in oracle?

1062

How to pass a parameter to a cursor in oracle?

1230

What are the roles of dba?

1136

What is meant by joins? List out the types of joins.

1104