Write a query to find second highest salary of an employee.
- 72 Answers
- 109462 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
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
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 javascriptexecutor and in which cases javascriptexecutor will help in selenium automation?
What is the deference between automation tools and management tools?
How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.
can any one please tell me QTP 9.2 supports which version of IE and Mozilla firefox.
If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.
hi to all, if we open a browser(for ex. yahoomail.com) using navigate command. the cursor by default focussing on the 'yahoo id' html edit box. how to get the label(ie.,yahoo id) of that html edit box using descriptive program. here we should not use identify tool to get the property,thtml editbox method. by tracing the cursor position we have to get the label name. is it possible? please let me know.
What are the advantages of the automation framework?
what is the dictionary objects in QTP? and what is method of vb script using virtual object wizard........
Discuss the economics of automation and the role of metrics in testing.
What is in-house tool?
What is vendor tool and give examples?
script to check availibility of mail in yahoo mail box in qtp
Explain what is the difference between findelement () and findelements ()?
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
