select level,max(sal) from emp where level=&levelno connect by prior s

how to findout the 100th maximum salary

Question Posted / maroju naveen

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

Please Help Members By Posting Answers For Below Questions

How many joins can you have in sql?

880

what is “go” in t-sql? : Transact sql

1038

What does plv msg allows you to do?

1074

What is memory optimized table?

984

What is identity column in sql server?

985

What is difference sql and mysql?

937

How do I restart sql?

912

What is difference between joins and union?

1042

How is use pl and sql?

1000

how can we submit a form without a submit button? : Sql dba

916

how to use myisamchk to check or repair myisam tables? : Sql dba

910

What is fmtonly in sql?

1004

what is a control file ? : Sql dba

985

Can we use pl sql in mysql?

959

What is before and after trigger?

889