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

Tell me how can we find the value of different attributes like name, class, value of an element?

1022

Tell me how could ajax controls be handled in webdriver?

982

How could the web element attributes be inspected in order to use them in different locators?

1009

What is tree view in automation testing?

986

Explain me what are the main advantages of automation testing?

962

What is the difference between automation tools and management tools?

1040

What you know about table-driven testing?

1098

Do you know what is a data-driven framework?

1040

Do you know what is robot api?

1004

What kind of tests should not be automated?

1050

Please explain what is the difference between findelement () and findelements ()?

1023

How will you automate basic “login” functionality test cases for an application?

963

What issues come up in test automation, and how do you manage them?

2481

What is ‘good code’? What is ‘good design’?

988

how to test an webbased application?

2061