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
Is ui level testing possible?
Tell us how to select a value in a dropdown?
What is Sikuli?
List some advantages and disadvantages of automation testing.
What is Ticketing tool? Has it any other names? What is the purpose of this?
Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com
What do you think holds the testers back to do automation? Is there a way to overcome it?
What are the limitations of automating software testing?
Give some examples for functional & regression test tools?
How you report bug in to bugzilla
What is the difference between continue and next sentence?
test cases test wheather window? test cases to test calculaor? test cases to test a reverse string program? test cases to test program{ int.parse(sting str) $return (int)}? test cases to test program{display string length}?
If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.
Is automation testing a black box testing or white-box testing?
How to Rcognize the Objects in the Web Page Dialog Using QTP