Answer / kapil singh chauhan

select * from
(select ID,Salary from employee order by Salary desc)
where rownum < 3

Answer / karan

select empname,sal from empdpt e where 1=(select count(*) from
empdpt where e.sal<sal)

Answer / nilesh

select * from employee2 e where 2=(select count(distinct salary) from employee2
where e.salary<=salary)

Its working.

Answer / ramu

select * from emp e where 2=(select count(sal) from emp
where e.sal<=sal)

Answer / saurabh

Answer 24 is correct , i have checked it.

Answer / mohan c v

select min(salary) from
(select top 2 salary from emp order by salary desc) as a

Answer / priyanka

select salary from emp where rowno=3 order by sal desc.

but this query works only when you have to create index.

Answer / ravi pahuja

selecl distinct top 2 salories from emp order by salory desc

Answer / girish

select max(salary) from emp where sal<(select max(salary)
from emp

Answer / chandan kumar

Select Top 1 salary from(select top 2 salary from emp_table
order by salary asc)

Differentiate between mongodb vs. Sql server?

0 Answers  

Explain different types of Normalization.

1 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

What are database states in ms sql server?

0 Answers  

Please differentiate between a local and a global temporary table?

0 Answers  

What is correlated subquery in sql server?

0 Answers  

Can group by and orderby be used together?

0 Answers  

wat is the main diff between sql server 2000and sql server 2005

6 Answers   Jade Software,

Why is sql server log file full?

0 Answers  

What is perspective, have you ever created perspective? : sql server analysis services, ssas

0 Answers  

hi, how to match retrieve the unmatched records from 2 tables in which we dont have any primary key. example : table1 has 1,2,3,4,5 and table2 has 1,2,3,4,5,6,7,8,9,10 and i want the numbers from 6 to 10 to be displayed and should not come as null. i need the numbers. please reply as soon as possible.

4 Answers  

How to Debug a Stored Procedure?

5 Answers   Allianz,

What is function of ROLLUP ?

0 Answers   HCL,