Interested to Buy Any Domain ? << Click Here >> for more details...
find out the third highest salary?
- 92 Answers
- 153719 Views
- CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon, I also Faced
- E-Mail Answers
Answer Posted / sanjeev kumar p
select * from emp e1 where (3-1) = (select count(distinct
(e2.sal)) from emp e2 where e2.sal>e1.sal)
| Is This Answer Correct ? | 99 Yes | 51 No |
Post New Answer View All Answers
What is meant by raw datatype?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
what is a Nested Loop join?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to assign data of the deleted row to variables?
What is memory advisor in Oracle?
How to use like conditions in oracle?
Difference between oracle's plus (+) notation and ansi join notation?
What is system tablespace?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
Which is faster join or subquery in oracle?
Explain an index segment?
State all possible different index configurations a table can possibly have?
What is the implicit cursor in oracle?
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?
