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 trigger in sql and its types?
What are sql functions? Describe in brief different types of sql functions?
What is the difference between cluster and non-cluster index?
Which join is like an inner join?
What is dialect in sql?
What are some emotional triggers?
What is the difference between numeric and autonumber?
Can a foreign key be a duplicate?
What is a sql profiler?
How to execute a stored procedure?
What are the set operators in sql?
how to run 'mysql' commands from a batch file? : Sql dba
What is implicit cursor in pl sql?
Explain unique key in sql.
What are types of exception?