Write a query to find second highest salary of an employee.

Answer Posted / priyanshu

select First_Name,Salary from employees where salary in
( select max(salary) from employees
where salary < ( select max(salary) from employees) ),

Is This Answer Correct ?    11 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me how can we find the value of different attributes like name, class, value of an element?

563


What is the purpose of deselectall() method?

489


What kind of tests should not be automated?

535


What should you do after finding a bug?

603


How do you identify the test cases which are suitable for automation?

524






What are the advantages of the automation framework?

509


What is mean by ARGO testing? Can you please explain anyone

1578


What are the steps involved in the automation process ?

720


why should we choose VSTET(Visual Studio Team Edition for Testers) and not QTP?pleas give me the reasons for "WHY" we have web and client server app, supports power builder and on windows OS so this is the background of tech and envir things we have and now VSTET is good to use or not? if "NO" then tell me why

1748


what are the questions that are generally asked in an interview if a person is having 3-4 years of exp..and in ds exp 2 yrs exp is wd automation testing

1469


Tell me the fundamental difference between xpath and css selector?

545


Tell us what is junit? And what is junit annotation?

501


Explain me what are the main advantages of automation testing?

471


Tell me what is tsl? What 4gl is it similar too?

560


How do select which automation testing tool is the best for you?

503