select First_Name,Salary from employees where salary in ( select

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

Question Posted / priyanshu

Answer Posted / priyanshu

select First_Name,Salary from employees where salary in
( select max(salary) from employees
where salary < ( select max(salary) from employees) ),

Is This Answer Correct ?

11 Yes

0 No

Please Help Members By Posting Answers For Below Questions

List some advantages and disadvantages of manual testing.

816

what is aom and how to add object repository? i am very new to QTP please help me

1884

How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.

2380

Do you know how to verify if the checkbox/radio is checked or not?

950

Where to maintain information like login, password and url?

878

Please explain what is the hybrid framework?

1008

Tell us what you know about table-driven testing?

918

8. How we test web based application

2235

WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?

2251

What is modular automation?

1040

What is the purpose of getoptions() method?

979

Define sdlc in testing.

975

I am testing a GIS based application so Can anyone tell me which automation testing tool is best for this application?

2846

why we cannot apply check points in compile modules?

2150

What is Sikuli?

978