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 left join in postgresql?

1044

What is a sql select statement?

1032

What is trigger point?

992

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

1091

What is pl/sql table? Why is it used?

1035

Are dml statements autocommit?

1040

Can you have a foreign key without a primary key?

951

What is difference between hql and sql?

1071

what are the advantages of sql ? : Sql dba

1055

What are sql injection vulnerabilities?

981

What is raw datatype in sql?

1042

How many subqueries can be nested in a statement?

980

How can check sql version from command line?

1079

what are the advantages of using stored procedures? : Sql dba

1103

how to select first 5 records from a table? : Sql dba

975