SELECT MAX(A.SALARY) AS MSAL FROM EMP A WHERE (SELECT MAX(B.SALARY) AS M

Write a query to find second highest salary of an employee.

Question Posted / parul

Answer Posted / 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;

Is This Answer Correct ?

2 Yes

4 No

Please Help Members By Posting Answers For Below Questions

What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...

2021

Tell us how to login into any site if it's showing any authentication pop-up for username and password?

1040

What is junit annotation?

1094

hi i would like to know is there any training institue for Calabash,robotium and ui automator in hyderabad...urgent

3117

Mention a few good practices while performing automation testing.

1021

We have a testing assignment that is time-driven. Do you think automated tests are the best solution?

2165

can any one please tell me QTP 9.2 supports which version of IE and Mozilla firefox.

2265

Simplify the term defect severity.

962

How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.

1737

Explain me what is the difference between setspeed() and sleep() methods?

1139

In general, how do you see automation fitting into the overall process of testing?

2092

Tell me how could the web element attributes be inspected in order to use them in different locators?

1101

What are the advantages of manual testing and automated testing?

959

Tell us what is junit? And what is junit annotation?

1087

how to test an webbased application?

2116