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;

I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....

0 Answers  

What is the process of Automation Testing?

0 Answers   Wipro,

Hi all I need QA automation testing interview questions. pls help me in this topic. The interview is related to verification & validation of web based products. ( i want questions based on this topic ) where can i find interview questions realated to this? This is urgent requriment for me. pls share your inputs. any kinda help appreciaed. warm regards Lina.

0 Answers   Rogers,

How do you identify the test cases which are suitable for automation?

0 Answers  

What issues come up in test automation, and how do you manage them?

0 Answers   HCL,

wat is difrenc btwn test case and test senario . can anybody know the answer just post it

3 Answers  

Can you tell some good coding practices while automation?

0 Answers  

Can anyone explain data driven frame work and keyword driven frame work.....

1 Answers   Bank Of America,

Hi friends, can anybody tell me what all the testing tools that persistant uses and what is the selection process for an fellow having 2yrs workexp on testing. Can anybody also help me out what is the minimum package that persistant is providing for 2yr workexp guy.

1 Answers  

Tell us how can you find if an element is displayed on the screen?

0 Answers  

Can any one give me the script for drag and drop or setselection functions ?like in a not pad i want to select 5 lines

0 Answers  

what is the dictionary objects in QTP? and what is method of vb script using virtual object wizard........

0 Answers   Quintegra,