select T.* from( select row_number() over (order by salary desc)as rno,sa

how to findout the 100th maximum salary

Question Posted / lince

Answer Posted / lince

select T.* from(
select row_number() over (order by salary desc)as rno,salary from table )T
where T.rno=100

Is This Answer Correct ?

0 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What is acid property in a database?

973

What is trigger and how to use it in sql?

950

What is user in sql?

966

What is trigger types in sql?

941

Why use triggers in sql?

890

what is normalization? : Sql dba

1014

how mysql optimizes distinct? : Sql dba

999

what is table? : Sql dba

981

Can we create index on primary key?

911

What is java sql driver?

1035

how to select first 5 records from a table? : Sql dba

918

What is the execution plan in sql?

970

What is the difference between stored procedure and view?

962

Is primary key a clustered index?

909

What are the different operators available in sql?

957