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
- 29354 Views
- Infosys, Rolta, I also Faced
- E-Mail Answers
Answer Posted / kavitha nedigunta
select a.ename,a.sal
from(select ename,sal,
dense_rank() over( order by sal desc nulls last) rk
from emp)a
where rk =5;
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is sql stand for?
What is a sql select statement?
How many rows can sqlite handle?
what are the differences between procedure-oriented languages and object-oriented languages? : Sql dba
How do you truncate?
How to add new employee details in an employee_details table with the following details
What does select top 1 do in sql?
Do triggers have restrictions on the usage of large datatypes, such as long and long raw?
Which command is used to delete a trigger?
How do you create an update query?
Explain 3 basic parts of a trigger.
what are the different index configurations a table can have? : Sql dba
Can we insert in view in sql?
What is delete command in sql?
