select top 1 * from Emp where Sal in (select top 100 Sal from Emp order b

how to findout the 100th maximum salary

Question Posted / goutham4mail@gmail.com

Answer Posted / goutham4mail@gmail.com

select top 1 * from Emp where Sal in
(select top 100 Sal from Emp order by Sal desc) order by
Sal asc

Is This Answer Correct ?

3 Yes

9 No

Please Help Members By Posting Answers For Below Questions

Differentiate between % rowtype and type record.

1303

define data blocks ? : Sql dba

996

What schema means?

888

What is sp_helptext?

1066

What is update query?

980

what is oltp (online transaction processing)? : Sql dba

1077

What is a dynamic query?

1022

How do I write a cron which will run a sql query and mail the results to agroup?

981

what are enums used for in mysql? : Sql dba

1170

What is delimiter in pl sql?

1062

What are the methods of filing?

935

Define concurrency control. : Transact sql

1191

What is data control language?

990

Explain how can you save or place your msg in a table?

1028

What are conditional predicates?

1059