how to get the second max val for every group in a table
Answer Posted / venkat
select * from (
select e.deptno,d.dname,e.sal,dense_rank() over (
partition by e.deptno
order by e.sal desc ) "RANK",
e.ename
from emp_test e,dept_test d
where e.deptno=d.deptno)
where rank=2
Is This Answer Correct ? | 9 Yes | 5 No |
Post New Answer View All Answers
Explain cascading triggers.
Give syntax for SQL and ORACLE joins.
How to delete multiple rows from a table in oracle?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?
Explain the difference between sap and oracle?
What is the data pump export utility?
What are joins, explain all types of joins?
How to select an oracle system id (sid)?
Explain rename?
How to connect the oracle server as sysdba?
What are a cluster and non-cluster index?
What is null value in oracle?
What are the different editions of oracle?
Respected sir, Please send me technical questions related to oracle apps..
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?