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 is not in sql?
explain the options of myisamchk to improve the performance of a table. : Sql dba
explain the delete statements in sql
In a distributed database system, can we execute two queries simultaneously?
What does select top 1 do in sql?
How do I view a view in sql?
explain what is mysql? : Sql dba
What is equi join in sql?
Will truncate release space?
Does pl sql work in mysql?
How do I make sql search faster?
what is meant by urlencode and urldocode? : Sql dba
How do I truncate a word?
What is primary key secondary key alternate key candidate key?
What is record data type?
