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

Answer Posted / vidhya

select max(column name) from table_name where((select max
(column name) from table_name Order by salary Desc) set
difference (select max(column name))

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me which web driver implementation is the fastest?

521


What is meant by the automation framework?

546


What are the things that one should consider for selecting a project for test automation? For example, stability, etc.

1570


what is dynamic window and dynamic model ? (worksoft automation tool)

1584


Tell us the line of code webdriver driver = new firefoxdriver();.?

516






Do you know what is a xpath?

549


Generic function for selecting a Radio Button in a Dialog

1975


explain add in manager and virtual object wizard in winrunner

1665


Types of F/w in Automation

841


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

588


What is a critical bug in a testing field?

562


Tell me how could ajax controls be handled in webdriver?

536


Manually in a page 10 check boxes is there.so 5 check box "on" and 5 check box "off" so using descriptive program how to know how many "on" and how many "off" plz help me this question answer?

1987


What is keyword driven automation?

590


Tell us how can you create html test report from your test script?

537