Write a query to find second highest salary of an employee.
- 72 Answers
- 108817 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 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
Tell us how could you explain the main difference between webdriver and rc?
Discuss the economics of automation and the role of metrics in testing.
how to map requirements& test cases in quality center ???
Tell us how do you get the width of the textbox?
Please explain how to perform load-testing?
How do you decide which tool you have to use?
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... :(
Explain some disadvantages to manual software testing?
How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.
Where to maintain information like login, password and url?
Elaborate the scripting standard while executing testing
What is test tool?
Tell us how can you find if an element is displayed on the screen?
What issues come up in test automation, and how do you manage them?
Explain what sikuli is?
