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

Explain table and field in sql?

1033

What is a sql schema used for?

1060

What does count (*) mean?

881

Can we create view in stored procedure?

923

What is difference between my sql and sql?

1021

What is sqlca in powerbuilder?

978

What is pl sql quora?

1101

Which is faster joins or subqueries?

950

How do I view stored procedures?

930

What is the plv (pl/vision) package offers?

1002

Where can I learn sql for free?

957

what is the difference between primary key and unique key? : Sql dba

995

How do I run a pl sql procedure in sql developer?

937

Is sql an operating system?

981

Does truncate table reset auto increment?

957