Answer / ravi

I write this query and it run !!

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


Plz reply if anyone having generic answer. :-)

Thanks

Answer / pradeep kumar

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

Answer / dharmaraj

SELECT max(salary) as salary FROM Employee WHERE salary <
(SELECT max(salary) FROM Employee)

Answer / vittal

select max(sal)from emp e1 where 2<=(select count(*) from
emp e2 where e1.sal <= e2.sal);

Answer / upali tejale

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

Answer / priyanshu

select First_Name,Salary from employees where salary in
( select max(salary) from employees
where salary < ( select max(salary) from employees) ),

Answer / sweety spear

select *from emp e1 where &n =(select count(*) from emp
where sal >= e1.sal);

Answer / murlidhar

select * from emp A where 2=(select count(*) from emp B
where A.sal < B.sal)

Answer / lokesh kanithi

Select * from emp e where 2=(select count(Distinct(esal))
from emp where e.esal<=emp.esal)

Answer / rajkumar mandala

select sal from
(select rank() OVER (order by sal desc) sno ,sal from emp)
y
where sno= n

here
y : is the alias name for (select rank() OVER (order by sal
desc) sno ,sal from emp)
n : is the number ie if u want second highest sal then 'n'
value will be 2. for third highest n= 3...

I am new to jmeter and i am working on .net application.I am recording the requests and pop up images data are not recording.can some one suggest an idea regarding this

0 Answers  

What are principles of good testing scripts for automation?

1 Answers   Fujitsu,

Sevirity & priority levels in bugzilla

3 Answers   TCS, Wipro,

Mention a few good practices while performing automation testing.

0 Answers  

I am using the selenium ide for testing my web application i recorded some script and played back while playing the recorded script the "alert msg is not getting closed" it needs manual interaction Please help out me

5 Answers   BSL, TCS,

What type problems faced in Recording the Apllication through WinRunner and QTP?

1 Answers   BirlaSoft,

Generic function for selecting a Radio Button in a Dialog

0 Answers   Ness Technologies,

Is web based application a 2 tier or 3 tier application.

2 Answers   Value Labs,

what r the diffence between QTP 8.2 & QTP9.0?

0 Answers  

Have you completed the cps exam? Which one?

0 Answers  

Tell me what criteria do you consider for automating a test?

0 Answers  

Tell us how do you get the width of the textbox?

0 Answers