SELECT employee_name FROM employee order by salary desc limit 1 offset 5

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

Question Posted / anil alpati

Answer Posted / anil alpati

SELECT employee_name FROM employee order by salary desc limit 1 offset 5 ;

Is This Answer Correct ?

0 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What is meant by <> in sql?

1031

How do I view an execution plan in sql?

1036

how to create a new table in mysql? : Sql dba

1037

What is denormalization in a database?

1107

What is difference between hql and native sql?

1240

Are pl sql variables case sensitive?

1093

How do you respond to dementia behavior?

1020

What is a database? Explain

1180

Differentiate pl/sql and sql?

1133

how to enter characters as hex numbers? : Sql dba

1104

What is %type in pl sql?

1014

How do I remove all records from a table?

1119

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1288

What is input buffer in sql*plus?

1293

What are sql indexes?

1050