how to get top two salaries from employee tables

Question Posted / maheswar

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

More Manual Testing Interview Questions

How can u know IP Address of a computer?

What is deferred status in defect life cycle?

in web application , what are the common "browser compatabality issues " that you have across.?

what is bugzilla? and how it is used?

How do you know your code has met specifications when there are no specifications?

If someone had 2 months experience in manaul testing but not that much effetive knowledge then what he should do show experience or not in his C.V.

tell me some major and minor defects in ur net banking project?

Can you explain v model in manual testing?

explain bug life cycle

What are the qualites should tester have?

what is the difference between PEGA based web application testing versus web application testing?

how can i derive the test case for requirement and usecase ?

For more Manual Testing Interview Questions Click Here