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 is the purpose of forms?

0 Answers  

how can u select the Distinct values in the table, table having 20 columns , i want all columns

2 Answers  

What is the difference between a local and a global variable?

5 Answers  

Explain multiserver query

0 Answers  

what is an extended stored procedure? Can you instantiate a com object by using t-sql? : Sql server database administration

0 Answers  

How to test odbc dsn connection settings?

0 Answers  

What is the maximum size of column in sql server?

0 Answers  

Explain the ways to controlling cursor behavior?

0 Answers  

What is 2nf normalization?

0 Answers  

what is meant by deafult in sql server?

2 Answers  

What are the two types of concurrency?

4 Answers  

What is log shipping?

0 Answers