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 meant by Priority and Severity?

2 Answers   Crea,


even though automation tools are fast and reliable why do we go for manual testing..in almost 90% of the companies manual testing is used

5 Answers  


how to test the cookies ?

2 Answers   IBM,


There is a Create Card window. It contains Card Name,Lunch discount & Dinner discount. I have written test cases for above [+ve & -ve].Now there is one Party discount is added to that window. How should I maintain test case.Guide me properly.I want to know that whether I have to write new test case bloking the previous one.

2 Answers  


Tell me about SOFTWARE DEVELOPMENT LIFE CYCLE? Explain in brief?

1 Answers  






Difference between JOB POSITION of Quality Assurance Engineer and software testing engineer.What are the responsibility for each?? It's really urgent.

3 Answers   CTS,


Does anyone have any good examples of some acceptance criteria for non-functional requirements?

0 Answers   IBM,


hi Will any one can be able to send the notes or any website for the ISTQB(Testing Certification) or any certification courses related to the testing(other than CSTE Exam) and about the fees details. U can send the information thr' mail also "geethapriyav_1980@yahoo.co.in" Thanks

1 Answers  


In which stage more defects found means anlaysis,design,coding,testing and maintance?

4 Answers   Accenture,


is it always necessary to do white box testing before doing black box testing.wat ar applications where only white box is done not black box testing,and application where only black box is benifical not white box testing

3 Answers   IBM, informatics,


what is verification and validation,

5 Answers   Hewitt,


Can you explain requirement traceability and its importance?

0 Answers  


Categories