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

Answer Posted / murlidhar

select * from emp A where 2=(select count(*) from emp B
where A.sal < B.sal)

Is This Answer Correct ?    41 Yes 36 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com

1521


1. How would you Test & then automate an antivirus application? 2. How would u test & automate windows screen saver? (expected: "test scenarios" & "test approch": points)

1639


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

1870


Explain me which web driver implementation is the fastest?

536


How the object properties will be recognised by the tool If the functions/ statements are written manually?

1739






Do you know the difference between close and quit command?

488


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

546


How to get the Background color of a Tab or Button in TestComplete Tool using VBScript? I have a validation that to verify whether a particular tab or button is highlighted or not. When the tab or button is highlighted the background color will be in Yellow color.If i get the background color then its easy for us to validate whether its highlighted or not. Can anybody help me on this?. Thanks in Advance.

4681


Is there any freeware tool for automation testing of mobile applications for BlackBerry and iPhone platforms ?

2503


Tell me what kind of tests should not be automated?

514


What kind of tests should not be automated?

545


Do you know what is the purpose of creating a reference variable- 'driver' of type webdriver instead of directly creating a firefoxdriver object or any other driver's reference in the statement webdriver driver = new firefoxdriver();?

510


Can you explain me what is object repository?

545


What you know about table-driven testing?

550


What are Keyword and Data driven frameworks in Selenium RC

2807