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)

What are the magic tables in SQL Server 2000?

7 Answers   Infogain, Merrill Lynch,

Explain some stored procedure creating best practices or guidelines?

0 Answers  

Create and insert into temp table in sql server?

0 Answers  

what information is maintained within the msdb database? : Sql server administration

0 Answers  

How do you create an execution plan?

0 Answers  

How do you start single user mode in clustered installations?

0 Answers  

Is port 1433 secure?

0 Answers  

Explain raiserror in sql server?

0 Answers  

What are the differences between substr and charindex in sql server.

0 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  

Explain what are partitioned views and distributed partitioned views?

0 Answers  

You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers