select max(salary) as salaryemp from employee where employee.salary<(se

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

Question Posted / saravanan.s

Answer Posted / saravanan.s

select max(salary) as salaryemp from employee where
employee.salary<(select max(salary) from employee)

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How you report bug in to bugzilla

2259

how to test an webbased application?

1999

List some advantages and disadvantages of automation testing.

875

What are the differences between open source tools, vendor tools, and in-house tools?

1004

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

2384

Tell me what databases can test director reside on?

873

Explain me what is a framework and what are the frameworks available in rc?

920

Which test cases can be automated?

941

WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?

2255

Does every software project need testers?

942

What should you do after finding a bug?

1065

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

932

Please name a couple of standard web function found in the function generator?

882

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

2959

What is open source tool and give example?

927