Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126066 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / jawad humayun
SELECT MIN(salary)
FROM employ
WHERE salary IN (SELECT salary
FROM employ
ORDER BY salary DESC
LIMIT 2)
This querry will give the 2nd highest salary
to have nth highest salary replace 'LIMIT 2' by 'LIMIT n'
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Hi All! Am new to Selenium and would really appreciate your help writing test cases for the following scenario: 1. Manually create 2 logins User A and User B on say, orkut.com or facebook.com. 2. Have User A invite User B as a friend. 3. Have User B accept the friend request. 4. Have User A post a comment on his own profile. 5. Have User B post a reply to that comment. 6. Each User logs out of his respective account. 7. Do not use Selenium IDE. 8. Use Selenium RC and Java.
What are the drawbacks of test automation?
Elaborate the scripting standard while executing testing
Explain some automation testing tools.
Can anyone tell me the correct answer of below question....it is about Bugzilla tool. When bug will find out at the time of executio where it will save or what is the location of bug??
What are the phases in automation testing life cycle?
What is the major difference between Functional test, Acceptance test, Usability test and performance test. With special reference to automotive domain
What are the different types of locks in mainframe?
Tell me what is a keyword-driven framework?
What is javascriptexecutor and in which cases javascriptexecutor will help in selenium automation?
It is a 30 days project & the client is in Singapur and we have to submit daily report regarding 1) What are the completed works, 2) What are the Pending Works ,3) Work planed for next day. You are free to assume regarding the project. can anybody help me to write an email to the client or Senior person who is staying in abroad
How the object properties will be recognised by the tool If the functions/ statements are written manually?
What is a framework and what are the frameworks available in rc?
notice the distinction between data driven testing and retesting?
Is automation testing a complete replacement for manual software testing?
