Answer / mitul deshmukh

Select Salary
from Employee emp
where
2 = Select Count(Salary) from Employee emp1
Where
emp.Salary >= em1.Salary))

Answer / ajay

SELECT * FROM employee WHERE salary=(SELECT MAX(salary) FROM employee WHERE employee.salary <
(SELECT MAX(salary) FROM employee))

Answer / krishnadevi

select max(sal) from emp where sal not in (select max(sal)
from emp

Answer / selvaraj

select max(salary) as salary from employee where
salary<(select max(salary) from employee)

Answer / subash chand

SELECT max(salary) FROM Employee WHERE Employee.salary <
(SELECT max(salary) FROM Employee);

Answer / nitin shrivastava

SELECT MAX(esal) AS salary
FROM Emp
WHERE (esal <
(SELECT MAX(esal) AS Expr1
FROM Emp AS Emp_1))

Answer / nitin shrivastava

SELECT MAX(esal) AS Expr1
FROM Emp
WHERE (esal NOT IN
(SELECT MAX(esal) AS Expr1
FROM Emp AS Emp_1))

Answer / manoj

Select max(salary) from emp where salary NOT IN (Select max
(salary) from emp)

Answer / dyson

select * from employee where
salary=(select max(salary) from employee where salary <(select max(salary) from employee))

Answer / aarti

select * from employees
where salary = (select mnin(salary)from (select salary from
employees where rownum <= 2 order by salary DESC)

Are reusable test cases a big plus of automated testing and explain why.

1 Answers  

How do you plan test automation?

0 Answers  

How to find that tools work well with your existing system?

2 Answers   EDS,

Tell me what kind of tests should not be automated?

0 Answers  

Tell us how could you explain the main difference between webdriver and rc?

0 Answers  

Hi every body.. Whn i install QC 9.2 in window xp sp2 it ll show the error msg as it will nt support. How can i install in this OS.. Plz plz help me and i installed IIS and oracle 8i.. Plz Plz help me for this one

1 Answers  

What is the scripting standard while performing automation testing?

0 Answers  

i am looking for HP QTP automated testing software, do you offers reselling this software or should i directly purchase with HP

1 Answers   HP,

what is the difference or comparison between QTP and rational? and which tool is better to use?

1 Answers  

Can you achieve 100% automation?

0 Answers  

On what basis we select test cases to automate?

1 Answers  

pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?

0 Answers