Answer / krishna

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

Answer / uday

select * from Emp e where 1=(select count(Distinct
d.esal)from emp d where d.esal>e.esal)

i am sure that it should work.


Any thing wrong plz inform me

Answer / k.elumalai

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

Answer / krishna

select * from emp e where 2>=(select count(distinct esal)
from emp where e.esal<=esal)

Answer / santhosh kumar

select Distinct Top 2 Salary from EMP order by Salary desc

Answer / sivashankar.soma

select ename,sal from emp E where 1=(select count(*) from
emp where E.sal<sal)

What does select 1 mean?

0 Answers  

What is the difference between function and stored procedure in sql server?

0 Answers  

Which institute is best for SQL Server 2005 Training?

6 Answers  

What does dml stand for?

0 Answers  

What are the types of backup and tell me the difference between full and differential backup?

4 Answers   CTS, TCS,

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

0 Answers  

explain different types of jions with examples briefly?

2 Answers   Accenture, Excellence, Zensar,

What is the use of partition by in sql server?

0 Answers  

How to get max 100 values from sql server

7 Answers  

When columns are added to existing tables, what do they initially contain?

0 Answers  

Once setting replication, can you have distributor on sql server 2005, publisher of sql server 2008?

0 Answers  

What should be the fill factor for indexes created on tables? : sql server database administration

0 Answers