Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128798 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
Do you know what is selenese?
Hi, I want to learn DataBase Testing. So please some document or path so that i can get some material on DataBase Testing concepts (preferably SQL Server 2000). Thanks in advance, Guru
Do you know how can we make one test method dependent on other using testng?
hi every one this is ashok pls any one give answer me pls question is while testing with selenium after giving id user name and password , the inbox will be open , how to handle this one
IN AN APPLICATION HOW DO YOU IDENTIFY THE TASKS WHICH SHUD BE DONE MANUALLY AND WHICH SHUD BE AUTOMATED?
What is test tool?
I want to learn the data base testing, how can I start my psactice? I already reading the books of basic for data base? If any other books that make my study simple please suggest.
What is keyword driven automation?
Why automation testing?
Can you explain me what is object repository?
you have same applications (same server configaration)A&B you are doing nonfunctionality testing . what they differ in?
When is automation testing useful?
all clients are using at once if any problem raise?
how to use regular expression in Test Complete Functional tool
Explain some automation testing tools.
