Write a query to find second highest salary of an employee.
Answer Posted / rajkumar mandala
select sal from
(select rank() OVER (order by sal desc) sno ,sal from emp)
y
where sno= n
here
y : is the alias name for (select rank() OVER (order by sal
desc) sno ,sal from emp)
n : is the number ie if u want second highest sal then 'n'
value will be 2. for third highest n= 3...
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
Can you achieve 100% automation?
What type of scenarios can't be automated?
What you know about table-driven testing?
Do you know how can we make one test method dependent on other using testng?
Tell me how can the user get a text of a web element?
How to login into any site if it's showing any authentication pop-up for username and password?
What is in-house tool?
Please name a couple of standard web function found in the function generator?
List some advantages and disadvantages of manual testing.
Name the frameworks that are used in software automation testing?
Differentiate between hdam and hidam database?
Tell me the fundamental difference between xpath and css selector?
what is the dictionary objects in QTP? and what is method of vb script using virtual object wizard........
Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(
Is automation testing in agile methodology useful or not?