how to get top two salaries from employee tables
Answer Posted / sivaprasad
SELECT MIN(SALARY) FROM EMP WHERE SALIN(DISTINCT TOP2
SALARY FROM EMP ORDER BY SALARY DESC.
OR
SELECT TOP 2 SALARY FROM EMP ORDER BY SALARY DESC.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Build with fixes has been deployed on QA environment if asked by your manager to reproduce how can you reproduce the issues? (by using the previous build) Can you access the previous build? If so ,what are the tools or how can you access?
Can some one help me writing a manual test case for email applications like yahoo i need for www.everonn.com
What are the different types of software testing?
What are the main key components in web applications?
write a testing stratgy \ approach for a product that you are use every day (e.g gmail, out look etc)
can anyone tell me the scenarios for online banking transaction ?
What do you understand by usability testing?
What's the difference between system testing and acceptance testing?
What do you do (with the project staff) when the schedule fails?
wat if fiddler and how it is used in tesing an application. please explain with a real time scenario
MS Paint
How to test the search functionality.For example in naukri advance search is there.how ca i test that page.
How could we start writing testcases without having the FRS,BRS Docs? My Project has some docs that are related to explain the operations which will be done in the application. It is deployed in UAT server and is a maintainance project. Tell me some technipues or best way to provide the quality to application?
What impact ratings have you used in your projects?
What are the main key components in web applications and client and server applications? And explain the differences between them?