Write a query to find second highest salary of an employee.
- 72 Answers
- 109332 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / nilesh chaudhari
Select max(Salary) as 'Second Highest Salary' from Employee
where USdollar NOT IN
(Select max(Salary) from Employee)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what is nTier Architecture understanding what is Microsoft ASP.net, ASP and SQL understanding what is Web Application and eCommerce application understanding what is Unit, System, Regression, FAT testing ? Test Automation and Test Script Authoring
How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.
What are the differences between open source tools, vendor tools, and in-house tools?
I am fresher and i have completed my software testing course and i don't have real time experience,can anybody help me regarding financial domain projects,main testcases in that domain.
List down the primary features of a good automation tool?
can anyone suggest me any low cost tool that can support both Manual and Automation testing ?
What are the main attributes of test automation?
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.
4. How we implement Winrunner,in our project?
How to Rcognize the Objects in the Web Page Dialog Using QTP
script to check availibility of mail in yahoo mail box in qtp
Generic function for selecting a Radio Button in a Dialog
Hi, here r some questions, which were asked in Ekaplus, plz process these questions. 1. How we connect with the version?
What do you think holds testers back to do automation? Is there a way to overcome it?
Mention a few good practices while performing automation testing.
