Select * from emp e where 2=(select count(Distinct(esal)) from emp where

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

Question Posted / lokesh kanithi

Answer Posted / lokesh kanithi

Select * from emp e where 2=(select count(Distinct(esal))
from emp where e.esal<=emp.esal)

Is This Answer Correct ?

27 Yes

22 No

Please Help Members By Posting Answers For Below Questions

What java api is required for generating pdf reports?

996

what is the difference between keyword driven frame work and data driven frame work.

2325

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

1003

What are the advantages of the automation framework?

981

Is automation testing a black box testing or white-box testing?

977

What are the steps to perform Load and Stress testing on a Website? What resources do I need to do this? Please advise. Thanks in advance.

1995

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

2212

2. How you will collect a module from the version?

2422

Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?

892

What is test automation or automation testing?

977

What are the various kinds of frameworks that can be used in software automation testing?

963

List of Test Management Tools??Is Quality Center Test Management tools

1769

How to decide the tool that one should use for automation testing in their projects?

1036

Tell me how a text written in a text field could be cleared?

934

Explain me which web driver implementation is the fastest?

989