Answer / rituparna

select salary from (select salary from emp order by salary
desc)
where rownum < 3;

Answer / maruti

select max(sal)
from emp
where sal < (select max(sal) from emp);

with this query u ll get second largest sal of that table
if u want to know max (sal) then it ll be...
select Max(sal)
from emp;

Answer / varu

This will be right answer for the query

Select * from empsal e where 2<=(select count(*) from empsal f
where e.sal>f.sal) order by sal desc

Answer / charan

hi this is charan,
select e1 *from employees e1
where 2>
( select column(distincte2.sal)
where e2.sal>e1.sal )

Answer / shiva - e-softsys

SELECT MIN (SALARY) FROM EMP WHERE

SALARY IN (SELECT DISTINCT TOP 2 SALARY FROM EMP ORDER BY
SALARY DESC)

Answer / usha

select top 2 salary from employee order by desc

Answer / rajendra prasad reddy penumall

this is a SQL query

SELECT DISTINCT salary FROM employee WHERE(max(salary))

Answer / satya

Hi,

Select * from emp e where 2>=(select count(*) from emp e
where sal>e.sal) order by desc sal.

Let me know if this query is wrong.

Answer / sivaprasad

SELECT MIN(SALARY) FROM EMP WHERE SALIN(DISTINCT TOP2
SALARY FROM EMP ORDER BY SALARY DESC.

OR
SELECT TOP 2 SALARY FROM EMP ORDER BY SALARY DESC.

Answer / varu

writing this way is also correct

select sal
from empsal
where id > 2
order by sal desc

When should testing start in a project? Why?

7 Answers  

What is difference between regression testing and re- testing?

17 Answers   Mind Tree, TCS,

what is entry / exit criteria and pass / fail criteria ?

1 Answers  

what techinques do u follow in suring testing?

1 Answers   ANZ,

what is Difference between Test Cases and Test Plan ? Give some Example Both of them

1 Answers  

a apllication is given to you but the requirements and functionalities are missing what will you do to start the testing?

10 Answers   Wipro,

why do you go for white box testing when black box testing is available?

6 Answers  

What is difference between Build, Version and Release

0 Answers  

what is RTM

6 Answers   Synergy,

Example For Load And Stress Testing.

2 Answers   Infoedge,

what is regression testing???

7 Answers   Ness Technologies,

What is Concurrency Testing?

1 Answers   PanTerra,