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 path for test director,where the test cases are stored ?

1 Answers  

what is test plan

8 Answers   CTS,

Enlist types of testing performed for any window in sequence?

1 Answers  

Hi harish n Satish...thanx for the response... Already told Functionality testing and user interface type testing to interviewer but he was expecting something else. And also explained test cases....Is it data driven testing for user id and password combinations? If i am not wrong....?

0 Answers   Cap Gemini,

What tool do you use in mobile testing?

1 Answers   Confidential,

Test cases for Recycle Bin

4 Answers   Quexst, Shriram,

IN V-Model, from where a tester involves and from where a developer will involve???

5 Answers   Oracle,

Why did you choose the Software Testing Field?

0 Answers   TCS,

what is the diffrence b/w QA and QC?

8 Answers   CIL,

when we enter wrongpaasword and wrong userid in login page and click on ok.it did not display that error msg. it displays that which page we want. what type of testing is this 1)functional testing 2)security testing

2 Answers   Encora,

Who Decide Severity And Priority ?

12 Answers   British Telecom BT,

Explain crud testing.

0 Answers