Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147727 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / raghav
select * from (
select Name,
Salary,
Dept,
Rank()over (order by salary desc) RANK
from Employee)
where RANK = 3
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
what's query optimization and without use of IN AND Exist can we get another way data from query
What is a proxy class?
Design database draw er diagram for a certain scenario ?
How many anonymous blocks can be defined?
How to define an explicit cursor in oracle?
Explain parameter file in oracle.
Give the advantages and disadvantages of clusters.
Explain the use of show option in imp command.
What happens to the indexes if a table is recovered?
Can we create trigger on materialized view in oracle?
How to run create database statement again?
Explain an exception?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to delete a column in an existing table?
How to store pictures on to the database?
