Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128349 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / rajeshraajan
SQL Server ( For 2nd max Salary )
---------------------------------
select Min(salary) from
( Select Top 2 salary from
( Select distint salary from Employee Order by
salary Desc ))
with this query we can find n th salary.
if am wrong plz correct me.
thx
| Is This Answer Correct ? | 53 Yes | 95 No |
Answer / lia
select employee_name
from employee
order by salary desc
where ROWNUM=2
| Is This Answer Correct ? | 31 Yes | 83 No |
What are the advantages of manual testing and automated testing?
Describe some problem that you had with automating test tool?
When will you not automate testing?
Tell me what type of scenarios can be automated?
How do you decide which tool you have to use?
What generally is the structure of a framework?
Do you know what is a xpath?
Suppose we r running a test which have 7 to 8 steps for different functionallity of and object..and suppose upto 4 step test passes but after 5th step test fails. what u will do in this condition will u start the test again or will u consider that rest steps will be working fine.
What factors determine the effectiveness of automation testing?
Which is a very good institute for QTP with VB script training center in kerala.Can you plz help any body
how is mind q venkat training in testing for weekend or general batches.and any other good institutes in ameerpet
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
WinRunner 
