How to get employee name from employee table which is the
fiveth highest salary of the table
Answer Posted / naresh
select salary from (select distinct(salary) from employee
oraderby salary desc) where rownum<=5;
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is the difference between having and a where in sql?
What information is needed to connect sql*plus an oracle server?
How to Execute a Package in PL/SQL.?
is mysql query is case sensitive? : Sql dba
Can two tables have same primary key?
What is the difference between alter trigger and drop trigger statements?
How do you write an index?
What is form and report?
what does it mean to have quoted_identifier on? What are the implications of having it off? : Sql dba
Is primary key a clustered index?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
what is 'trigger' in sql? : Sql dba
how do you know if your mysql server is alive? : Sql dba
What is the maximum number of triggers, you can apply on a single table?
What can sql server reporting services do?