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 a trigger word?

0 Answers  

What is the difference between delete and truncate statement in sql?

0 Answers  

what is offset-fetch filter in tsql? : Transact sql

0 Answers  

how to check the 3rd max salary from an employee table? One of the queries used is as follows: select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal). Here in the sub query "select count(distinct(sal)) from emp b where a.sal<=b.sal" or "select count(distinct(sal)) from emp b where a.sal=b.sal" should reveal the same number of rows is in't it? Can any one here please explain me how is this query working perfectly. However, there is another query to get the 3rd highest of salaries of employees that logic I can understand. Pls find the query below. "select min(salary) from emp where salary in(select distinct top 3 salary from emp order by salary desc)" Please explain me how "select sal from emp a where 3=(select count(distinct(sal)) from emp b where a.sal<=b.sal)" works source:http://www.allinterview.com/showanswers/33264.html. Thanks in advance Regards, Karthik.

4 Answers  

how will be date change into string

4 Answers  

What is sql integrity?

0 Answers  

What is difference between cursor and ref cursor?

1 Answers  

What are the pre requisites?

1 Answers  

Why functions are used in sql?

0 Answers  

how is exception handling handled in mysql? : Sql dba

0 Answers  

Why cannot I use bind variables in ddl/scl statements in dynamic sql?

0 Answers  

Are subqueries faster than joins?

0 Answers