Interested to Buy Any Domain ? << Click Here >> for more details...
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
What are pl sql procedures?
What is a relationship and what are they?
What is trigger in pl sql?
Why plvtab is considered as the easiest way to access the pl/sql table?
how tsql statements can be written and submitted to the database engine? : Transact sql
What is restrict in sql?
Is primary key clustered index?
what is foreign key? : Sql dba
Is left join and outer join same?
what is the difference between truncate and delete statement? : Transact sql
What are aggregate functions in sql?
Sql technical questions
What is difference between joins and union?
What is a rank in sql?
what is a materialized view? : Sql dba
