how to get top two salaries from employee tables

Answer Posted / rituparna

select salary from (select salary from emp order by salary
desc)
where rownum < 3;

Is This Answer Correct ?    10 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what types of testing have u done in ur project?and expalin it detail?

1537


How soon the bug should get fixed?

620


Could someone please send me real check list for Database Security testing.Please my mail ID- patil.ramchandra@yahoo.co.in. Thanks.

1820


Hi,friends i am going to write ICST certificate exam on augest.So can anybody post some of sample qusetions for ICST certificate exam.Really it will be useful for me

1580


What are the various techniques in black box testing?

723






Hi there, I am new to the world of testing. Is there any place where I can have a look at an actual specification documents or test plans or test cases. This will help me in generating a level of confidence. Looking forward to your replies

1445


can you tell me how to write test cases for payments, receipts, inward clearing, outward clearing, A/c statements ?

1641


What is neutral test case?

1808


If there is non reproducible bug which developer is not ready to agree, how you will convince him.

7602


Sentence "Working from onsite is effective" is growing in IT field. How do we bring that knowledge to offshore and do an effective job in Offshore?

1668


Artifacts in design phase of SDLC ?

3065


What are the main key components in web applications and client and server applications? And explain the differences between them?

666


what is the technical challange you faced in your module.please ans me the question i just want example can me any example please very important

1481


What is the difference between code walkthrough and code review? What is the difference between walkthrough and inspection?

2489


Do you think tools are required for managing change. Explain and please list some tools/practices which can help you managing change.

1637