how can find the second max sal for every group(i.e i want
group the data based on key and find the second max sal for
every group
- 2 Answers
- 5076 Views
- Verizon, I also Faced
- E-Mail Answers
Answer Posted / nathan
SELECT *
FROM (SELECT deptno, sal,
DENSE_RANK () OVER (PARTITION BY deptno ORDER
BY sal DESC)
ranks
FROM emp)
WHERE ranks = 2;
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What is connection pooling in oracle?
Which environment variables are absolutely critical in order to run the OUI?
What is oracle rownum?
What is oracle server autotrace in oracle?
How to create a new oracle data file?
What is Data Dictionary Cache in Oracle?
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
Explain enable novalidate constraint.
What are the ways tablespaces can be managed and how do they differ?
What happens if recursive calls get out of control?
What are the restrictions in a oracle read only transaction?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
How would you begin to troubleshoot an ORA-3113 error?
