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 many file formats are supported to export data?

1221

What is an oracle user role?

986

what happened to the global index when I truncate the data in one of the partition?

2027

What is meant by joins?

1063

How to login to the server without an instance?

1167

How to define an oracle sub procedure?

1151

What is a cursor variable?

1137

What do you understand by database schema and what does it hold?

1233

Can select statements be used on views in oracle?

1029

What is a cursor in oracle?

1181

Can you have more than one content canvas view attached with a window ?

2333

What is the use of aggregate functions in oracle?

1026

What are joins, explain all types of joins?

2299

How to connect to the server with user account: sys?

1024

What view(s) do you use to associate a users SQLPLUS session with his o/s process?

2356