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 create a temporary table in oracle?

1264

What is a cognitive schema?

958

What is concurrency in oracle?

1005

How to define an anonymous procedure with variables?

1151

Which is faster join or subquery in oracle?

986

What is Virtual Private Database in Oracle?

1083

Explain index?

1254

How to drop a stored procedure in oracle?

1051

Differentiate between function and procedure in oracle.

1071

What the is the diff between local index and global index. give some example.

1638

Is it possible to insert comments into sql statements return in the data model editor ?

2552

What is a cursor and what are the steps need to be taken?

1196

What is recovery manager in Oracle?

1050

Explain the difference between a procedure and a function? What do you understand by those terms?

1077

What is the best way to do multi-row insert in oracle?

1065