Answer / aj.com

SELECT MAX(SALARY) FROM EMPLOYEE WHERE SALARY NOT IN (SELECT
MAX(SALARY) FROM EMPLOYEE)

Answer / shyam

select max(salary) as '2nd Highest Salary'
from Employee a
where 2<=(select count(*) from Currencies b where a.salary
<= b.salary);

Answer / nilesh chaudhari

Select max(Salary) as 'Second Highest Salary' from Employee
where USdollar NOT IN
(Select max(Salary) from Employee)

Answer / saravanan.s

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

Answer / rajesh kole

SELECT MIN(Sal) FROM Employee
WHERE Sal IN
(SELECT TOP 4 Sal FROM employee ORDER BY Sal DESC)

Answer / sup

SELECT TOP 1 salaryamount
FROM (
SELECT DISTINCT TOP 3 salaryamount
FROM mstsalary
ORDER BY salaryamount DESC) a
ORDER BY salaryamount

--sup--

Answer / hardit

select TOP 1[salary]
from(
select distinct TOP 2[salary]
from empTable
order by salary desc
) a
order by salary

Answer / kedo

select sal from
select * from employee orderby salary DESC
Limit 1,1

Answer / harikrishna ravipati

select max(sal) from emp where sal <
(select max(sal) from emp)

Answer / chandramami

SELECT MAX(e.salary)
FROM emp e,emp e1
WHERE e.salary<e1.salary;

What are the different types of scripting techniques for automation testing?

0 Answers  

Tell me what are the different types of navigation commands?

1 Answers  

wat would be the parameteries for ul testing for web applilcation

0 Answers  

Plz suggest me a tool which supports ActiveX controls

3 Answers  

What are the advantages of test automation?

0 Answers  

i have recorded a scrip for some window applicaiton(login screen) and i have used browser as IE and i have executed sucessfully that script. and now i want to execute the same scrip in different browsers and i question is wether it the same script will execute in different browsers or not

2 Answers  

Does every software project need testers?

0 Answers  

Explain Bug Life Cycle and expalin briefly each 'Status' also

4 Answers  

what is nTier Architecture understanding what is Microsoft ASP.net, ASP and SQL understanding what is Web Application and eCommerce application understanding what is Unit, System, Regression, FAT testing ? Test Automation and Test Script Authoring

0 Answers  

Any quality test-tracking tool which has live & automated dashboards so that the entire team is updated at any given point of time?

1 Answers  

what is the framework your fallowing in your organization while using automation tool ?

0 Answers   ADP,

please guide me to get some automation tool for functional testing in freeware and how to work with it?Its emergency

1 Answers