Write a query to find second highest salary of an employee.
- 72 Answers
- 108796 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / vidhya
select max(column name) from table_name where((select max
(column name) from table_name Order by salary Desc) set
difference (select max(column name))
| Is This Answer Correct ? | 2 Yes | 5 No |
Post New Answer View All Answers
Any kind of test which you think should not be automated?
What criteria do you consider for automating a test?
Why automation testing?
how to import specifically 2nd column elements to runtime datatable in excel sheet if it contains 3 columns
Explain me what is a framework and what are the frameworks available in rc?
What is ‘good code’? What is ‘good design’?
Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)
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
What are the differences between open source tools, vendor tools, and in-house tools?
Tell me what are the different types of navigation commands?
What is an automated test script?
Generic function for selecting a Radio Button in a Dialog
What is junit annotation?
How to select an automation tool best matched for your project?
what is the difference between Batch test runner and framework ?
