Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the second max val for every group in a table
- 6 Answers
- 9687 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / suman rana
select * from emp e where 2 = ( select count(distinct sal)
from emp e1 where e1.deptno = e.deptno and E.SAL <= E1.SAL)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Calculate difference between 2 date / times in oracle sql?
Explain oracle’s system global area (sga).
List the various oracle database objects?
What is meant by raw datatype?
How can we find out the current date and time in oracle?
What is a Garbage Collection? and what is full recursive Garbage collection?
Explain the use of rows option in imp command.
Whether any commands are used for months calculation? If so, what are they?
How to connect to a remote server?
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?
What is meant by recursive hints in oracle?
How to select some columns from a table in oracle?
Explain the use of record option in exp command.
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Explain table?
