Answer / sudheer

select salary from employee e
where 100=(select count distinct salary) from employee where
e.salary<=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

Answer / soumya

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

Answer / lince

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

Answer / xyz

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

Answer / ethayan

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

Answer / ramu

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

Answer / murali

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

What are field types?

0 Answers  

What does plvtab enables you to do when you showthe contents of pl/sql tables?

0 Answers  

What is thread join () in threading?

0 Answers  

if a table is getting updated what happens if a function is called from sql query?

2 Answers   RBS,

What is a rank in sql?

0 Answers  

What is the difference between UNIQUE CONSTRAINT and PRIMARY KEY? 1. There is no difference. 2. A PRIMARY KEY cannot be declared on multiple columns. 3. A UNIQUE CONSTRAINT cannot be declared on multiple columns. 4. A table can have multiple PRIMARY KEYS but only one UNIQUE CONSTRAINT. 5. A table can have multiple UNIQUE CONSTRAINTs but only one PRIMARY KEY.

7 Answers   Satyam,

How do I count duplicates in sql?

0 Answers  

what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba

0 Answers  

What is pragma in sql?

0 Answers  

what are the disadvantages of mysql? : Sql dba

0 Answers  

what is purge command explain about oracle performance tuning

2 Answers   Accenture, eCentric Solutions,

what are the advantages a stored procedure? : Sql dba

0 Answers