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 the INSTEAD OF trigger do?

3 Answers  

How global temporary tables are represented and its scope?

0 Answers  

What is a cursor, index in sql?

0 Answers  

what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration

0 Answers  

What are the High-Availability solutions in SQL Server and differentiate them briefly?

0 Answers  

Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s

6 Answers   Broadridge,

How to list all tables in the database using odbc_tables()?

0 Answers  

What is a transactions?

0 Answers  

HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY IN EMP TABLE

18 Answers   Infosys, TCS,

What is tabulation?

0 Answers  

If we delete pack Spec what will be the status of pack Body ?

0 Answers   Nagarro,

Explain the database you used in your final year project?

0 Answers   Wipro,