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

What are the limitations of automating software testing?

0 Answers  

Give some examples of priority – severity defect levels.

0 Answers  

can you ple give me Quality Center interview questions and answer

5 Answers  

What are the drawbacks of test automation?

0 Answers  

In selenium testing how to connect with database , any one pls give the entire information

2 Answers  

What is quality assurance?

10 Answers   HCL,

What is vendor tool and give examples?

0 Answers  

why should we choose VSTET(Visual Studio Team Edition for Testers) and not QTP?pleas give me the reasons for "WHY" we have web and client server app, supports power builder and on windows OS so this is the background of tech and envir things we have and now VSTET is good to use or not? if "NO" then tell me why

0 Answers  

Do you know how to check if a button is enabled on the page?

0 Answers  

How will you choose a tool for test automation?

1 Answers  

What testing activities you may want to automate?

0 Answers  

5. What are the tests you are conducting through winrunner?

0 Answers   Eka Software,