Interested to Buy Any Domain ? << Click Here >> for more details...
How to get employee name from employee table which is the
fiveth highest salary of the table
- 20 Answers
- 29493 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / mrunali
select name from (select e.*, dense_rank() over (order by salary desc nulls last)as rn from emp e) where rn=5
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What type of database is sql?
What does varchar include?
What is auto increment?
Explain the purpose of %type and %rowtype data types?
How to order siblings in oracle hierarchy queries?
How do I find sql profiler?
What is bulk collect in pl sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Explain constraints in sql?
What is a sql select statement?
Does a primary key have to be a number?
Is sqlexception checked or unchecked?
What is index example?
Is sqlite free?
define sql insert statement ? : Sql dba
