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

Which is faster view or stored procedure?

886

Can we commit in trigger?

920

What does sql stand for?

941

What is the difference between subquery and correlated query?

982

Does sql require a server?

939

Is sqlite free?

907

What is pl sql in oracle?

987

What is the difference among union, minus and intersect?

949

What is the difference between a query and a report?

900

Is it mandatory for the primary key to be given a value when a new record is inserted?

1139

what does myisamchk do? : Sql dba

961

What does pl sql stand for?

1062

Explain the difference between triggers and constraints?

919

what is a trigger? : Sql dba

973

what is bdb (berkeleydb)? : Sql dba

968