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 user defined functions?
What is a heap in sql?
Can a trigger call a stored procedure?
What is sql injection vulnerability?
what does myisamchk do? : Sql dba
What is rtm in testing?
What is trigger in flip flop?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
What is a scalar value in sql?
What is partition by in sql?
Explain dml and ddl?
how to do backup entire database? : Transact sql
What is delimiter sql?
What is index example?
How is sql used in oracle?