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

Answer Posted / vikash

--SUPPOSE PRICE IS SALARY

SELECT
TOYNAME,TOYPRICE FROM TOY
WHERE TOYPRICE<(SELECT MAX(TOYPRICE) FROM TOY)ORDER BY
TOYPRICE DESC LIMIT 1;

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define sdlc in testing.

582


In Selenium how a test suit is run and report is generated.

1958


What is the purpose of the wrun.ini file?

586


Please explain what is a relative xpath?

565


did anybody take online training from Mind Q systems hyderabad? please share your experience. thanksĀ 

1746






Can you explain me what is object repository?

549


WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT

1724


What are the primary features of good automation tool ?

582


What is Sikuli?

616


How do you choose which automation tool is best for your specific scenario?

553


Can we find all links on a web page?

527


Elaborate the scripting standard while executing testing

513


Please explain what is the hybrid framework?

585


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

535


What are pros and cons of automating tests at ui layer?

551