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)

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

0 Answers  

Does table partitioning improve performance?

0 Answers  

What are the type of joins? When do we use Outer and Self joins?

3 Answers  

how to overcome kernel isssues

0 Answers   Fortune,

Explain the disadvantages of cursors?

0 Answers  

What is the difference between rank and dense_rank?

0 Answers  

Tell me about builtinadministrator?

0 Answers  

How can you insert values in multiple rows using one Insert statement?

0 Answers   Flextronics, Thomson Reuters, Virtusa,

What is the purpose of self join?

0 Answers  

What is the security principal at the database level that represents your session?

0 Answers  

what are acid properties? : Sql server database administration

0 Answers  

How to turn on the mssql api module in php?

0 Answers