select employee_name,salary from employee order by salary desc limit 1 offs

How to get employee name from employee table which is the
fiveth highest salary of the table

Question Posted / ramu

Answer Posted / ramu

select employee_name,salary from employee order by salary desc limit 1 offset 4;

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is synonyms?

999

Explain constraints in sql?

984

What do you understand by pl/sql packages?

1020

What is clustered index sql?

934

Can you have a foreign key without a primary key?

901

What is the difference between drop and truncate commands?

999

What is compute?

1016

How can I speed up sql query?

907

Why use stored procedures?

1020

What is rownum in sql?

967

Why do we need a foreign key?

1023

What is the mutating table and constraining table?

969

explain mysql aggregate functions. : Sql dba

941

What are the commands used in sql?

1017

what is uncommittable transactions? : Transact sql

956