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

Can you explain function points?

0 Answers  

what is android testing?

2 Answers  

what is server-side testing? what is automation framework?

1 Answers   HCL,

what is the difference between test strategy and test methodology?

3 Answers   Uniken,

how many members are involved in test plan? and tell me names?

3 Answers   Wipro,

developers take most of the time for coding and tester left very few time for testing say 2 days which testing u find best when ur project is run out of time and product is going to be released

3 Answers  

Write test cases for checking date field?

1 Answers   Wipro,

Retesting will be coducted on particuler bug or entair application?

6 Answers  

what is mean by computer standards,with ex?

4 Answers   IBM,

When do you prepare Requirement Traceability Matrix(RTM) before testing aor after completion of testing?

14 Answers   AppLabs, IEG, Satyam,

3.risk factor ratio in the project?

2 Answers  

What procedure you follow between gathering requirements and carried out testing?

2 Answers   STG,