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

Answer Posted / ayyappa

Select max(esal) from emp where esal < (Select max
(esal) from emp)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)

4941


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

588


Explain how to perform load-testing?

611


What are the attributes of a good framework?

578


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






Explain me which web driver implementation is the fastest?

550


Hello, Is there any source from which i can get any live tutorial or trial of Automation tools?? Also i have a query that is there any certification course or exam available for Automation tools QTP and QC?

1334


What is the difference between automation tools and management tools?

547


In what condition we cannot use automation testing for agile method ?

646


Please explain how to perform load-testing?

583


What steps are needed in developing and running a software test?

552


How to select an automation tool best matched for your project?

516


What is test driven development?

618


What is self-referencing constraint in mainframe development?

513


Tell me how could ajax controls be handled in webdriver?

536