select sal from ( select row_number() over (order by sal desc) as rno,sal

how to findout the 100th maximum salary

Question Posted / lince

Answer Posted / lince

select sal from
(
select row_number() over (order by sal desc) as rno,sal
from Emp
)T
where T.rno=100

Is This Answer Correct ?

0 Yes

2 No

Please Help Members By Posting Answers For Below Questions

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

979

how can we know the count/number of elements of an array? : Sql dba

1069

What are literals in sql server?

1180

what is the difference between a local and a global temporary table? : Sql dba

1079

What is sql query optimization?

1125

What is error ora-01000: maximum open cursors exceeded

1154

What does the argument [or replace] do?

1094

what is the difference between group by and order by in sql? : Sql dba

1134

Explain what is sql?

1121

What is primary key and unique key?

1123

Can we use loop in sql?

972

What is the use of sql trace?

960

Enlist some predefined exceptions?

1068

What is the size of partition table?

1049

what is subquery? : Sql dba

1141