Write a query to find second highest salary of an employee.
Answer Posted / shahnawaz
please check this one .
first rank the salary coloum and then find nth heigest
salary
use rank function
select * from
(select a.*, rank()over(order by salary desc) rn from
emp_shah a)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
pls tell me any open source test case managment tool ? its urgent.also tell me any autmation testing tool also for functional testing?
Explain about basics of rational robot - ibm test automation tool?
What is test driven development?
Currently I do not have any automation in place in my project, but now I want to implement automation, what would be my steps?
What is hybrid automation?
How will you automate basic “login” functionality test cases for an application?
Can anyone tell me the correct answer of below question....it is about Bugzilla tool. When bug will find out at the time of executio where it will save or what is the location of bug??
What is in-house tool?
Tell us how do you get the width of the textbox?
Explain some automation testing tools.
Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com
Please explain what is a relative xpath?
What are the steps involved in the automation process ?
Tell me how could the web element attributes be inspected in order to use them in different locators?
Explain me what is testng and why is it better than junit?