Interested to Buy Any Domain ? << Click Here >> for more details...
Write a query to find second highest salary of an employee.
- 72 Answers
- 129005 Views
- ABC, Cognizant, MegaSoft, Netwin Infosolutions, Nippon, Polaris, Satyam, SGS, TCS, Verisoft, I also Faced
- E-Mail Answers
Answer Posted / bhaskar reddy thamma
SELECT DISTINCT (a.sal) FROM EMP A WHERE &N = (SELECT COUNT
(DISTINCT (b.sal)) FROM EMP B WHERE a.sal<=b.sal);
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What generally is the structure of a framework?
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
notice the distinction between data driven testing and retesting?
Hi all, Do anyone have the experience in PDF Document Automation using OLE objects and methods? If so suggest the best websites for source. Thanks :-)
What are the phases in automation testing life cycle?
How did you use automating testing tools in your job?
What are the limitations of automating software testing?
What are the advantages of automation testing?
WHAT IS TEST SCRIPT AND HOW DO YOU CREATE IT?
What is testng and why is it better than junit?
What is self-referencing constraint in mainframe development?
Any one suggest me for Free ware (Opensource) Automation tool for regression testing.
What are the drawbacks of test automation?
What is the purpose of deselectall() method?
Write a short compiled module which selects random numbers?
