how to get top two salaries from employee tables

Answer Posted / varu

writing this way is also correct

select sal
from empsal
where id > 2
order by sal desc

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the difference between website and web based application ?

2264


What is meant by Boundary value analisis and Equalence partitioning? Can give derive this using these methods? In a system designed to work out the tax to be paid: An employee has £4000 of salary tax free. The next £1500 is taxed at 10% The next £28000 is taxed at 22% Any further amount is taxed at 40% Which of these groups of numbers would fall into the same equivalence class? a) £4800; £14000; £28000 b) £5200; £5500; £28000 c) £28001; £32000; £35000 d) £5800; £28000; £32000

1593


Explain crud testing.

651


What is your approach when requirements change continuously?

719


what are the functional test cases for enter user name,enter pass word,click on ok(only functional test cases)

1951






What are the two main categories of software testing?

692


What are the main key components in client and server applications?

700


hi, this is geetha, i have one doubt regarding the vulnerability testing. For sql injection testing is there any need for the tools to be installed. If it is what is tool and what is the method to test in sql injection testing. Plz Guide me

1606


Can you explain the workbench concept?

708


What are the standard you follow in your company to prepare test plan document? Content is same in every standard or not. Also is there any document to read about the testing standards? Thanks in advance for giving me the answer.

1555


Architectural structure of the insurance project?

771


What if the project isn’t big enough to justify extensive testing?

791


Can you please explain me how to do testing of an E-insurance project end to end process..

2208


Can anyone please tell in detail about the Rally tool and how a tester is going to use it.

2073


What is desk checking and control flow analysis

764