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
- 28591 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
If a cursor is open, how can we find in a pl/sql block?
how to write date and time literals? : Sql dba
Can a view be mutating? If yes, then how?
What is consistency?
How do you concatenate in sql?
What does count (*) mean in sql?
Which command is used to call a stored procedure?
explain the difference between bool, tinyint and bit. : Sql dba
Does a user_objects view have an entry for a trigger?
How does sql developer connect to oracle database?
What are sql commands?
what is the command line end user interface - mysql? : Sql dba
Where is all the data on the internet stored?
what are sequences
What do you mean by stored procedures? How do we use it?
