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 is inline view?

15 Answers  

take one table is t1 and in that column name is f1 f1 column values are 200 5000 3000 7000 300 600 100 400 800 400 i want display the values asc and desc in a single output. sample output is f1.a 100 200 300 400 500 600 etc...... and f1.d is 5000 4000 3000 2000 1000 etc...

9 Answers   Zensar,

How do I start sql from command line?

0 Answers  

What is the use of a view in sql?

0 Answers  

why not null constraint showing its constraint type as 'c'

1 Answers  

What's the procedure?

0 Answers  

if we give update table_name set column_name= default. what will happen?

4 Answers   iFlex,

How do we use distinct statement? What is its use?

0 Answers  

write a query to display diference between two dates in sql server

2 Answers  

What is a pdo connection?

0 Answers  

How do I get sql certification?

0 Answers  

What does an inner join do?

0 Answers