how to get top two salaries from employee tables

Answers were Sorted based on User's Feedback



how to get top two salaries from employee tables..

Answer / selvakumar

select salary
from emp
where rownum <= 2
order by salary.

this query will list top 2 salaries

Is This Answer Correct ?    0 Yes 1 No

how to get top two salaries from employee tables..

Answer / suresh

Hi,
This is suresh.
My answer for that query is

select top 2(salary)from emp order by salary desc

Is This Answer Correct ?    5 Yes 8 No

Post New Answer

More Manual Testing Interview Questions

What is Facet Testing?

7 Answers   Cognizant,


can any one give the example for high severity high priority high severity low priority low severity high priority low severity low priority

10 Answers   TCS, Wipro,


Advantage and disadvantage of waterfall model,v model and iteration or incremental model?

2 Answers   Philips, TCS,


How will u satisfy Ur Client,P.M,T.L?it need to satisfy clients,P.M,T.L?

1 Answers  


What is the clear meaning of test case, levels in test case ? contents of test case

2 Answers  






what is Project Sign Off?what you consider at this point?

5 Answers  


When do we perform smoke testing?

0 Answers  


how to indentify memory leakages after the build

0 Answers  


Tell me some Adhoc testing scenarios of ebay (online auction product)?

0 Answers  


What is Inter-System Testing? Please answer me frnz!!!

4 Answers  


define risk management system with example ?

0 Answers   ITC Infotech,


At what stage of the life cycle does testing begin?

6 Answers  


Categories