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

i have doubt suppose iam purly working in manual, when i will work on sql and performence testing? pls any one clarify doubt?

3 Answers  

As a tester I found a show stopper(critical defect) this evening whereas the project is going to be delivered to the client tomorrow morning so there is no time left.I reported the same to my test manager but he is not ready to convinced with me moreover he wants to close the matter as it is....in this senario wat will u do???

3 Answers   SuperValu,

Can u tell something about the Agile Methodology

2 Answers   Infosys,

how will you estimate of your website?

0 Answers  

What is XML Testing? Do we have any tools to test the XML? Please let me know.

0 Answers  

What is meant by Metrices?What is purpose of Metrices in Testing?What is Template for that?PLZ REPLY ASAP.Thanks in advance.

1 Answers  

what are the tests u did in entire project? when it did in the project? (means at the release build to end of project) plz explain clearly

0 Answers   HCL,

what exactly done parallely in v-model with verification.

2 Answers  

What is the difference between latent and masked defects?

0 Answers  

What is actually a rule based testing

0 Answers   ISPL,

how u do database testing

4 Answers   Polaris,

What is web based application?

3 Answers