Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 150712 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / santhoshkumar
select name,salary from emp where salary=(select min(sal)
from (select distinct TOP 3(salary) from emp order by
salary desc;
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
What is the Tune Query
What is the difference between PFILE and SPFILE in Oracle?
What is a connect identifier?
How to write an inner join with the where clause in oracle?
How to recover a dropped table in oracle?
What are triggers in oracle?
What do you mean by cdb and pdb in oracle 12c?
How to add a new column to an existing table with a default value?
How to convert csv to table in oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?
What is a schema in oracle?
How to drop a stored function?
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.
