Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 128256 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 sal,(row_number() over (order by sal)) N from emp ) y where N= {value}
Replace {value} value with required highest value.
ie, 2 for 2nd highest
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
On what basis you can map the success of automation testing?
HOW DO YOU PERFORM SECURITY TESTING TO VERIFY FIREWALLS,PASWORD ENCRYPTOPNS ETC?
What type of scenarios can't be automated?
how to re-install QTP 11.0 trial version
We have a testing assignment that is time-driven. Do you think automated tests are the best solution?
What is ‘good code’? What is ‘good design’?
How to integrate Rational functional Tester with Rational Quality manager. Can anyone provide the details steps giving explaination with examples.
Do you know what is the purpose of creating a reference variable- 'driver' of type webdriver instead of directly creating a firefoxdriver object or any other driver's reference in the statement webdriver driver = new firefoxdriver();?
if i want to use different values in datatable with each iteration of for loop what would i do ??/
Anyone aware of Test Runner (ETL Automation Testing tool) if so please help me with material in keerthi.smile14@gmail.com
I want to learn the data base testing, how can I start my psactice? I already reading the books of basic for data base? If any other books that make my study simple please suggest.
What is functional and regression testing?
What is tree view in automation testing?
When you will not automate testing?
Give some examples for defect management tools?
