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 dba in sql? : SQL DBA

1039

Explain the methods used to protect source code of pl/sql.

1015

what is normalization? : Sql dba

1082

Are null values same as that of zero or a blank space?

1024

Why plvtab is considered as the easiest way to access the pl/sql table?

1211

What are triggers and its types?

1055

What is a scalar value in sql?

1070

How do I tune a sql query?

973

what is auto increment? : Sql dba

1005

What is sql profiler in oracle?

1087

What are actual parameters and formal parameters?

1101

What is sql injection vulnerability?

940

What is the difference between having clause and where clause?

1057

How do rank () and dense_rank () differ?

1044

Can we create clustered index without primary key?

962