Answer Posted / maroju naveen
select level,max(sal) from emp where level=&levelno
connect by prior sal>sal
group by level;
This is Nth max(sal) query.....
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain polymorphism in pl/sql.
When do we use triggers?
What is difference between my sql and sql?
How to select all records from the table?
What is exception? What are the types of exceptions?
Can we call procedure in select statement?
Is pl sql a scripting language?
What is rename command in sql?
What is procedure explain with program?
What is the use of count (*) in sql?
Explain the methods used to protect source code of pl/sql.
Does inner join remove duplicates?
Is inner join same as self join?
What is auto increment in sql?
when MSQL8.0 is in market
