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
Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com
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)
2. How you will collect a module from the version?
Explain me which web driver implementation is the fastest?
How the object properties will be recognised by the tool If the functions/ statements are written manually?
Do you know the difference between close and quit command?
How do you choose which automation tool is best for your specific scenario?
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.
Is there any freeware tool for automation testing of mobile applications for BlackBerry and iPhone platforms ?
Tell me what kind of tests should not be automated?
What kind of tests should not be automated?
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();?
Can you explain me what is object repository?
What you know about table-driven testing?
What are Keyword and Data driven frameworks in Selenium RC