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

What is the difference between Client server and web based systems?

2 Answers  

What is P.M Round? What type of questions are they asking? ? If know anybody Plz Post to my mail ID (SwetharaoQA@rediffmail.com) Thank U

2 Answers  

where did u gather requirements? what is user acceptance testing? in real time plz send me as early as possible?

2 Answers   CTS,

What is the difference between Developer and programmer?

13 Answers   Tech Mahindra,

What is the Regression Testing Process followed in your company?

3 Answers   HCL,

Explain Automation Vs Manual Testing?

1 Answers   Crea,

What are different types of metrics used in testing ?

1 Answers  

how to indentify memory leakages after the build

0 Answers  

hi ,, what is testing methodologies ,and what is test strategy pls tel me ... advance thanks for all

2 Answers   Synergy,

i am in a small size software house join as a Jnr. software Testing Engineer so here is project is on Coding and almost finished stage, no Test cases or any QA activities done b4 now can any body explain me how can i continue... m realy depresd coz m just doing manual testing by running the process n m good in this phase but i wanna know abt is QA is just doing that way....plz help me

2 Answers  

1.how you know all test cases are cover in one application? 2.what is difference between error message and warning message ? 3.what are the items comes under traceabily materix?

7 Answers   iSoft,

Hello every one.I want to learn Manual Testing. I'm new to Testing.can anyone send me Manual testing books or any free download links?

1 Answers