how to findout the 100th maximum salary

Categories >> Software >> Databases >> SQL PLSQL
Suggest New Category

Question Posted / jyothi1331

28 Answers
30264 Views
Amdocs, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

how to findout the 100th maximum salary..

Answer / sudheer

select salary from employee e
where 100=(select count distinct salary) from employee where
e.salary<=salary

Is This Answer Correct ?

3 Yes

8 No

how to findout the 100th maximum salary..

Answer / 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

how to findout the 100th maximum salary..

Answer / soumya

select * from (select rownum, salary from emp order by
salary ) where rownum=100;

Is This Answer Correct ?

3 Yes

9 No

how to findout the 100th maximum salary..

Answer / 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

how to findout the 100th maximum salary..

Answer / xyz

select rownum, salary from (select salary from employees order by salary desc)
where romnum<=100

Is This Answer Correct ?

0 Yes

8 No

how to findout the 100th maximum salary..

Answer / ethayan

select salary from (select salary from sample where
rownum<11 order by salary desc) where rownum<2

Is This Answer Correct ?

3 Yes

12 No

how to findout the 100th maximum salary..

Answer / ramu

select top(100) salary from table1 where salary not
in(select top(99) salary from table1)

Is This Answer Correct ?

1 Yes

11 No

how to findout the 100th maximum salary..

Answer / murali

select salary from (select salary from table order by salary
desc) v where rownum<=100

Is This Answer Correct ?

8 Yes

19 No

Post New Answer