find out the third highest salary?
Answer Posted / paridhi
select top 1 salary from
(select top 1 salary from employee order by
salary desc) a
order by salary
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is oracle the best database?
How to define an anonymous block?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
How to use subqueries with the in operator using oracle?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
How to invoke the original export import utilities?
How to delete a column in an existing table?
How to convert csv to table in oracle?
nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls
what is dynamic SGA and static SGA
What is meant by joins?
How to do paging with oracle?
Explain enable novalidate constraint.
How to filter out duplications in the returning rows using oracle?