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
What is test tool?
Define sdlc in testing.
Why automation testing?
What factors determine the effectiveness of automation testing?
Tell me how can the user get a text of a web element?
8. How we test web based application
i need test cases for defect maganement tools
Can you tell some good coding practices while automation?
What are the phases in automation testing life cycle?
Which is the best place to learn Loadrunner performance testing in hyderabad ?
what is nTier Architecture understanding what is Microsoft ASP.net, ASP and SQL understanding what is Web Application and eCommerce application understanding what is Unit, System, Regression, FAT testing ? Test Automation and Test Script Authoring
Tell us what is the alternate way to click on login button?
What are the pre-requisites to start automation testing?
What kind of tests should not be automated?
Which protocol cam be used to makw jdbc connection woth loadrunner