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 transaction server isolation?

0 Answers  

How many types of built in functions are there in sql server 2012?

0 Answers  

Can we add our custom code in ssis?

0 Answers  

Which database stores information about replication?

0 Answers  

Does index speed up select statements?

0 Answers  

What are the different types of indexes?

0 Answers   Blue Star,

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

What are data resources?

0 Answers  

What is auditing in sql server?

0 Answers  

Explain what is sql server english query?

0 Answers  

Which data type columns are the best candidates for full-text indexing?

0 Answers  

What is row by row processing ?

2 Answers