how to get top two salaries from employee tables

Answer Posted / satya

Hi,

Select * from emp e where 2>=(select count(*) from emp e
where sal>e.sal) order by desc sal.

Let me know if this query is wrong.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the typical risks that you identify during test planning and their mitigation plan and Contengency plan.

2009


How to validate a Testcase.and is the testing Methodology.

1843


Can some one help me writing a manual test case for email applications like yahoo i need for www.everonn.com

1533


Testcases for msword( microsoct office word??

1670


Is quality control similar to quality assurance?

647






how to write defects in excel sheets when defects occured

1530


I have 2 yr Localisation testing exp now i want to job in MNC My manualtesting knowledge+2 yr exp sufficiant for in MNC

1587


write test case for gmail login page

4643


What is frame level testing and how do we test it?

1974


What is difference between Build, Version and Release

1689


Describe your experiences with code analyzers.

1741


can anyone tell me the scenarios for online banking transaction ?

1668


I want to do certification in ISTQB please anybody hepl me with the details and site to refer for further details.............if possible give me the material as well on my mail id a.vishwakarma@aol.com. Please help me........Thanks

1696


10 scenarios for security testing using gmail applications?

7576


Hi, this is murthysharma. I need very urgently about some terms which are used in use cases? Plz give reply to me, if any body know, It is really very very urgent. 1. what is the difference between basic flow,exception flow and alternative flow? 2.what are non-functional requirements in use cases? 3.what are exceptions, special requirements, business rules, assumptions, constraints. Kindly give me with the example. Bcoz, I am very new to this use cases. thanks in Advance. Regards, M.MurthySharma

1532