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

How do I view a sql database?

1023

What is trigger types of trigger?

1073

What can you do with pl sql?

1097

What are the disadvantages of file system?

1268

How can we find duplicate records in a table?

948

How many columns should be in an index?

963

What is a database trigger?

1072

how is exception handling handled in mysql? : Sql dba

1084

what is recursive stored procedure? : Sql dba

989

What is orm in sql?

1052

what is the difference between mysql_fetch_object and mysql_fetch_array? : Sql dba

1068

Can a foreign key have a different name?

941

what is not null constraint? : Sql dba

1038

What does trigger mean in psychology?

963

What is compiled query?

1041