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

Answer Posted / ramu

select employee_name,salary from employee order by salary desc limit 1 offset 4;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain aggregate functions are available there in sql?

752


Define tables and fields in a database

836


Is it possible to link two groups inside a cross products after the cross products group has been created?

769


Can we insert data in view?

691


Is sql microsoft?

710






What programs use sql?

732


How do you truncate?

661


What is the syntax and use of the coalesce function?

814


Is and as keyword in pl sql?

686


What is localdb mssqllocaldb?

805


What is file based approach?

664


What is ttitle and btitle?

768


How much does sql cost?

735


how to use in conditions? : Sql dba

695


What is dml and ddl?

713