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

Explain oracle instance.

1102

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

2297

Which is better Oracle or MS SQL? Why?

6260

How can I introduce multiple conditions in like operator?

920

How to define an explicit cursor in oracle?

984

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

954

How to create an initialization parameter file?

980

Explain what does a control file contain?

1029

11. Display the client number and name and the client number and name of the person who referred that client.

2270

How would you go about verifying the network name that the local_listener is currently using?

1989

Explain index?

1195

How to write a query with an inner join in oracle?

972

Can we connect to ORACLE db using Windows Authentication?

1178

What is a database schema in oracle?

1052

Can we write dml statement in function in oracle?

1021