Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 147717 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / ayaz mahmood
select max(sal) from emp
where sal= (select max(sal) from emp
where sal< (select max(sal) from emp
where sal< (select max(sal) from emp)))
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to use subqueries with the exists operator in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is transport network substrate (tns) in oracle?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
Explain an extent?
Write a syntax for update query in oracle?
What is different types of joins?
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to connect to oracle using service name instead of sid?
what is partitioning? Types of partitioning. explain? what is the new kind of partitioning type introduced in 9i?
What is Undo Management Advisor in Oracle?
11. Display the client number and name and the client number and name of the person who referred that client.
What is partitioned table in Oracle?
What is analyze command used for?
What is difference between cartesian join and cross join?
