Write a query to find second highest salary of an employee.
- 72 Answers
- 109297 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / rk
select sal from
(select rank() OVER (order by sal desc) sno ,sal from emp)
y
where sno= n
here
y : is the alias name for (select rank() OVER (order by sal
desc) sno ,sal from emp)
n : is the number ie if u want second highest sal then 'n'
value will be 2. for third highest n= 3...
| Is This Answer Correct ? | 5 Yes | 5 No |
Post New Answer View All Answers
if i want to use different values in datatable with each iteration of for loop what would i do ??/
1.Which functinalities of QTP using in onlinebanking system? 2.in lift which kind of testing you perform? 3.how do you test money is transform from one account to another account in online banking?
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
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
hi, I want to study TIA portla V11. where can I get online courses?
Hi everyone, Are you looking for "worksoft certify" automation tool training online? We have experienced corporate Worksoft certify trainers. We also provide support Worksoft certify automation issues. Please contact us Automationsolutions@yahoo.com
Give some examples of priority – severity defect levels.
what r the diffence between QTP 8.2 & QTP9.0?
Tell me what is a keyword-driven framework?
What is functional and regression testing?
I am new to Test Complete ,can any one suggest me the steps to create/Record and replay a test in Test complete 6....
what are the steps followed in unit testing, system testing, integration testing
i need test cases for defect maganement tools
Do you know what is the difference between "type" and "typeandwait" command?
What is the purpose of getoptions() method?
