Write a query to find second highest salary of an employee.
- 72 Answers
- 109265 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / rajkumar mandala
select sal from
(select sal,(row_number() over (order by sal)) N from emp ) y where N= {value}
Replace {value} value with required highest value.
ie, 2 for 2nd highest
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
Discuss the economics of automation and the role of metrics in testing.
How do you identify the test cases which are suitable for automation?
What is the difference between close and quit command?
In what condition we cannot use automation testing for agile method ?
Explain me what kinds of annotations are used in testng?
Currently I do not have any automation in place in my project, but now I want to implement automation, what would be my steps?
Do you know what is functional testing?
Bug report formate in bugzilla
I want a code for a following item in TSL Language. Look up a person in database, If not found, add person to the database.
Explain load testing on websites?
Tell me how could the web element attributes be inspected in order to use them in different locators?
What issues come up in test automation, and how do you manage them?
Do you know what is a data-driven framework?
How could the web element attributes be inspected in order to use them in different locators?
Explain what is the difference between findelement () and findelements ()?
