Write a query to find second highest salary of an employee.
Answer Posted / ashutosh singh
select distinct(a.Sal) from emp a where &n=(select
count(distinct(b.Sal)) from emp b where b.Sal<a.Sal)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How will you automate basic “login” functionality test cases for an application?
Do you know how to verify if the checkbox/radio is checked or not?
What is test tool?
What is extreme programming and what has it got to do with testing?
Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?
if we are using an Engine (tool)..with that how to capture data from excel sheets and how to do automation with this plz answer any body for this question.?
What are the things that one should consider for selecting a project for test automation? For example, stability, etc.
When will you not automate testing?
What java api is required for generating pdf reports?
Tell me what is automation testing?
What are different coverages in function testing?
List some advantages and disadvantages of automation testing.
Tell me what is tsl? What 4gl is it similar too?
What are the advantages of automation testing?
When is automation testing useful?