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


Please Help Members By Posting Answers For Below Questions

Is ui level testing possible?

560


Tell us how to select a value in a dropdown?

538


What is Sikuli?

624


List some advantages and disadvantages of automation testing.

520


What is Ticketing tool? Has it any other names? What is the purpose of this?

1551






Anyone have idea of jmeter.IF so pls contact to this mail id arun130887@hotmail.com

1535


What do you think holds the testers back to do automation? Is there a way to overcome it?

570


What are the limitations of automating software testing?

1516


Give some examples for functional & regression test tools?

509


How you report bug in to bugzilla

1854


What is the difference between continue and next sentence?

523


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}?

1763


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.

1477


Is automation testing a black box testing or white-box testing?

521


How to Rcognize the Objects in the Web Page Dialog Using QTP

2011