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
- 9419 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
List the parts of a database trigger.
What is set operator oracle?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is a relational database management system?
How to name query output columns in oracle?
How to connect to oracle using service name instead of sid?
Which environment variables are absolutely critical in order to run the OUI?
What are advantages of dateset in datastage?
What is data type in oracle?
How do I connect to oracle?
When do I need to use a semicolon vs a slash in oracle sql?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
what is a Nested Loop join?
Explain oracle 12c new features for developers?
What is an oracle user account?
