Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 126038 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / parul
SELECT MAX(A.SALARY) AS MSAL
FROM EMP A
WHERE
(SELECT MAX(B.SALARY) AS M1SAL
FROM EMP B) < MSAL
AND A.SALARY = B.SALARY;
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
Explain me what kinds of annotations are used in testng?
HOW DO YOU PERFORM SECURITY TESTING TO VERIFY FIREWALLS,PASWORD ENCRYPTOPNS ETC?
Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com
can anyone suggest me any low cost tool that can support both Manual and Automation testing ?
List some advantages and disadvantages of manual testing.
What u mean by infrgistics control (What is infrgistics Controls)?
Why do you prefer selenium automation tool?
1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?
What are the differences between open source tools, vendor tools, and in-house tools?
In what condition we cannot use automation testing for agile method ?
Tell me what is tsl? What 4gl is it similar too?
Simplify the term defect severity.
Tell us how to login into any site if it's showing any authentication pop-up for username and password?
Can we do automation testing without a framework? If yes, then why do we need a framework?
What are the different types of an automation tool that you are aware of?
