how to findout the 100th maximum salary
Answers were Sorted based on User's Feedback
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 |
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 |
Answer / soumya
select * from (select rownum, salary from emp order by
salary ) where rownum=100;
Is This Answer Correct ? | 3 Yes | 9 No |
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 |
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 |
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 |
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 |
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 |
How can you get sql*loader to commit only at the end of the load file? : aql loader
How would you convert date into julian date format?
What does plvtab enables you to do when you showthe contents of pl/sql tables?
How many sql statements are used?
Q1.all the depts which has more then 10 empls? Q2.all the dept which does not have any emply? Q3 all the emp which does not have any dept? Q4 get all the emply detais with the dept details it dept is exit otherwise any emp details? Q5 how to debugg the dynamic sql and packages?
how to connect oracle in unix prompt?
Why is theta join required?
what are properties of a transaction? : Sql dba
What is a package ? What are the advantages of packages ?
How to call a javascript function from pl sql?
Is sql easier than java?
How does one load ebcdic data? : aql loader