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...

how can i count the no of edit field in a page and fill the multiple edit field

0 Answers   Toshiba,

Hi I need the following information about JMeter 1) How many(max) threads(users) can hit the website using Jmeter? 2) How long(in hours) can we run Jmeter for stress test? (Is there any “Memory full” issue if we run for long time?) 3)What typeof sampler to use for clicking on the link?

0 Answers  

How can the user get a text of a web element?

0 Answers  

What is vendor tool and give examples?

0 Answers  

what is test complete tool? Which are most important terms in it? please give little introduction of it.

1 Answers  

On what basis you can map the success of automation testing?

0 Answers  

Tell us what is the difference between single slash (/) and a double slash ( //) in xpath?

0 Answers  

What is the difference between close and quit command?

0 Answers  

How t o create Libreary files on QTP

2 Answers  

What is the memory size of one object repository file in Qtp

5 Answers   Wipro,

Explain me what is a framework and what are the frameworks available in rc?

0 Answers  

what are test metrics

1 Answers