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

Answer Posted / avi007

SELECT employee_name,min(salary) FROM ( select distinct
salary from employee order by salary desc)
where rowno<6 group by employee_name;

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to return query output in html format? : Sql dba

651


how to check server status with 'mysqladmin'? : Sql dba

569


Is left join faster than join?

549


How do I create a sql database?

524


What is normalization sql?

513






What is crud stand for?

570


What are triggers in sql?

581


Does truncate release storage space?

560


What is on delete restrict?

540


Explain spool.

691


What are the different parts of a package?

635


What is dcl in sql?

528


What is use of term?

624


What are actual parameters and formal parameters?

570


how does a local variable is defined using t-sql? : Transact sql

546