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

Answer Posted / anil alpati

Select empsal From emp order by empsal desc offset 5 limit 1;

Is This Answer Correct ?    0 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is 'mysqlshow'? : Sql dba

756


Explain what is rdbms?

784


What is a trigger in sql?

890


How do I find duplicates in a single column in sql?

738


what is difference between delete and truncate commands? : Sql dba

812






What is the difference between nvl function, ifnull function, and isnull function?

800


What type of database is cloud sql?

780


In a distributed database system, can we execute two queries simultaneously?

752


What is pivot in sql?

670


How to convert comma separated string to array in pl/sql?

812


how to concatenate two character strings? : Sql dba

748


Can we use rowid as primary key?

738


What are the commands used in sql?

744


What is normalization sql?

724


Enlist the advantages of sql.

747