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

diff b/w alpha & beta testing? who will do this with examples? can u pls help in this topics

3 Answers  


what is internalization?

5 Answers   Oracle,


what is functional testing?Explain with one example?And when we use functional testing in your project???

2 Answers   TCS,


is software testing easy ??? Give me perfect Ans.

3 Answers   SunGard,


Which testing approach you follow to test ATM machine?

1 Answers  






what is the diff bet two tier and three tier arch?

2 Answers  


What steps are needed to develop and run software tests?

1 Answers   Crea,


Im a 2005 graduate i did testing course from a reputeted institute but was nt able to get a job as a fresher so i got an fack certificate in tat i included 2 prjs based on web site testin cud ne one tell me wat will be questions cud be fired for me as a 2yrs exp in manual testing .. ill be great full of all urs

6 Answers  


trecebality matrix used for which purpose?

8 Answers   Cap Gemini,


What r the input documents to the design test cases?

7 Answers   Covansys,


What is the difference between Business Requirement and functional Requirement

3 Answers  


What is a test strategy?

2 Answers  


Categories