Write a query to find second highest salary of an employee.
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
Where do we get the QTP and Load runner softwares CDs ( Original ) in chennai
What is a xpath?
What u mean by infrgistics control (What is infrgistics Controls)?
Explain me what are the main advantages of automation testing?
Name some of the commonly used automation testing tools that are used for non-functional automation.
In what condition we cannot use automation testing for the agile method?
What you know about table-driven testing?
What are the phases in automation testing life cycle?
Why do you want to keep this kind of information in a separate file and not directly in the code?
Please name a couple of standard web function found in the function generator?
How software testing is handled?
What are the important operations in database testing?
Tell me what type of scenarios can be automated?
Please explain how to perform load-testing?
Give some examples for functional & regression test tools?