Answer / sirish kumar

Select max(salary)from(select salary from employee where
salary not in(select max(salary)from employee))

Answer / rahul koul

Select MAX(SALARY) from EMP where SALARY NOT IN (SELCT MAX
(SALARY) from EMp)

Answer / saima

1.
SELECT * TOP 1 from
(Select Top 2 from employee Order By Salary desc)
order By salary desc

2.
SELECT * from
(Select Top 2 from employee Order By Salary desc)
where salary <max(salary).

Answer / amit rajput

Select Min(NetAmount) from (Select Distinct Top 9 NetAmount
from vw_im order by NetAmount desc) a


This will give you 9th highest Salary

Answer / sisara bharat

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


Plz reply if anyone having generic answer. :-)

Thanks

Answer / biswojit kar

Getting nth max sal of an Employee.

select sal from (select ename,sal, dense_rank() over(order
by sal desc nulls last) as rank from emp) where rank=n;

Here n = 2 for 2nd highest sal, 3 for 3rd highest sal, 4
for 4th highest sal and so on.One can use rank() in place
of dense_rank(), but the demerit of rank() is as follows:
Let you want to see 3rd highest sal.
Suppose 2 employees have 2nd highest sal, then rank()
assigns both of them rank 2, then it leaves a gap and
assigns the emp with 3rd highest sal to rank 4.
So, when you use the above query with rank(), the you donot
get the 3rd highest sal. Try retrieving 3rd highest sal in
emp table in scott user, using both rank() and dense_rank
(), and mark the diff. Thanks!

Answer / tausif

select top 2 * from Employee order by salary desc

Answer / prem

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

Answer / parul

SELECT MAX(A.SALARY) AS MSAL
FROM EMP A
WHERE
(SELECT MAX(B.SALARY) AS M1SAL
FROM EMP B) < MSAL
AND A.SALARY = B.SALARY;

Answer / vikash

--SUPPOSE PRICE IS SALARY

SELECT
TOYNAME,TOYPRICE FROM TOY
WHERE TOYPRICE<(SELECT MAX(TOYPRICE) FROM TOY)ORDER BY
TOYPRICE DESC LIMIT 1;

Who is the best faculty for Automation testing in hyderabad

0 Answers  

You have 3 Dialog Box on desktop window and u want to click on yes button on 3rd Dialog box how to write the script to click on yes by DP? Note Dialog box names are same

1 Answers   Wipro,

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

1 Answers  

WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?

0 Answers  

Do you know what is a xpath?

0 Answers  

What are the advantages of test automation?

0 Answers  

Hi All, Is there any free automation tool for windows application and it's easy to use? I usually take a lot of time to regression test my application when there is a new build on live environments (about same 10 environments) I wish I know a automation tool to regression test and ofcourse it's free, easy to use (maybe using C#) Could anybody can advise to me a tool like that? I very appreciate ^^

0 Answers  

Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(

0 Answers   Telelogic,

How can a mainframe application be tested using Automation tools. I mean which is the best tool to do Mainframe testing?

2 Answers   GE, Xansa,

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

0 Answers  

What are the limitations of automating software testing?

0 Answers  

what is mutation testing ? when we are using this type of testing?

3 Answers   JVS,