Select max(salary) from emp where salary NOT IN (Select max (salary) from

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

Question Posted / pradeep kumar

Answer Posted / pradeep kumar

Select max(salary) from emp where salary NOT IN (Select max
(salary) from emp)

Is This Answer Correct ?

95 Yes

16 No

Please Help Members By Posting Answers For Below Questions

Tell us which package can be imported while working with webdriver?

1118

Explain me what the webdriver supported mobile testing drivers do you know?

1038

Elaborate the fields in bug report in automated testing

1037

What is hybrid automation?

1072

What are the 5 common software development problems solutions?

1061

is there any one got offer from snapdeal?

4609

IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?

2358

Do you know when autoit is used?

1084

what is GDC

2221

Tell me which web driver implementation is the fastest?

1047

4. How we implement Winrunner,in our project?

2512

What type of scenarios can be automated?

1032

how to write ciertification in QTP?

2186

What is keyword driven automation?

1114

Elaborate the scripting standard while executing testing

1085