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 are the different types of sql commands?

1176

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1224

How can I speed up sql query?

1006

what are date and time data types in mysql? : Sql dba

1020

What are %type and %rowtype for?

1106

What is pl/sql language case sensitive?

1181

Is left join faster than inner join?

1168

Which nosql database is best?

1023

what is the difference between group by and order by in sql? : Sql dba

1185

how to present a past time in hours, minutes and seconds? : Sql dba

1069

What is the difference between a query and a report?

1053

what is the difference between rownum pseudo column and row_number() function? : Sql dba

1133

What do you mean by rowid?

1023

What are the indexing methods?

1098

What is a full join sql?

1103