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 differences between substr and charindex in sql server.

0 Answers  

Explain the disadvantages/limitation of the cursor?

0 Answers  

Differentiate between SQL and ORACLE joins and write their syntax.

0 Answers   Global Logic,

What are the difficulties faced in cube development? : sql server analysis services, ssas

0 Answers  

What are sql servers used for?

0 Answers  

How optimize sql query with multiple joins in sql server?

0 Answers  

As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?

0 Answers  

Explain how to send email from sql database?

0 Answers  

Can I know,how to Execute Funcion and Trigger through command(Manualy Execution) in MS SQL/SERVER 2005,give me answer with Example.

1 Answers  

Scalability, Availability, Integration with internet, etc.)?

0 Answers  

wat wil hapn if we give the both read and deny read permission to user?

0 Answers   IBM,

What are the different editions available in sql server 2000?

0 Answers