how to get top two salaries from employee tables

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Give the real-time example for back-to-back testing?

1372


In what situation would you want to parameterize a text verification check?

1688


what are risks and contigencies(solutions) of an ecommerce (online shopping and bidding project)application?we describe this in Test plan can anyone tell me abt this?

1578


Scenario A year ago we developed a standards compliant website for a client. Their site is very popular resulting in the client wanting to be able to track how it is being used by their users. The first part of this project is to create a Login function so that users can be identified on the website. The data supplied by users would have to be handled securely. You have been allocated this project to work on. You will be responsible for the task from start to finish and will be expected to give feedback to your manager. User expectations  The client wants their users to be able to login using a page that fits in with the website design.  Tom wants to access the website but doesn’t want his login information to be available to anyone else.  Paul doesn’t want to login to the website because he’s not a frequent user. Task Please provide some feedback on how you would do the following:-  Being the only Test Engineer on this task, what would your approach be for this requirement?  Identify the key areas for testing this page.  What tools if any, would you use to perform the testing, bearing in mind that the testing will be done without using an ‘automated test tool’.  Provide a sample test case that could be used for testing this page, for example as a word or Excel document.

1458


Genarally what we have to tell. If anybody asks in the interview. what are challenges u faced in the Project and what are the Risks u faced in the Project, Anybody can suggest it ......Thanks in Advance....

1725






Login screen with Username, Password input fields,remember me check box,sign in and reset button write Test Cases for GUI, Funcitonal, Negative, Usability and Security testing.

2290


What are parametere require for Performance testing?

1923


What is the difference between system testing and integration testing?

644


Describe some staff conflicts you have handled.

1618


define Testing of Procedure, Triggers and Functions in data base testing ?

3052


is it not possible to automate full project??what r the parts in project that cant be automated(tht has to be done manually)?

1997


1) Test summary contains ? 2) Requirement Tracebility means ? 3) Test Effort contains ? 4) Test Planning Productivity ? 5) Metrics should be caluclated ? 6) Interest rate Rsik is a type ? 7) Test analysis and Design process task? 8) secured loan is a part of Liability (or) assest in a balance sheet? 9) Money Market means? 10) a ------ specifies all of the terms of a loan and the obligations borrower ? 11) what is a primary market is ? 12) Quality of Testing measure with ? 13) Company has a share with facevalue 10 rs/- and NAV of 37 after comapny has given Dividend of 35 % then How much NAV become ? ( I don't know what is NAV means, question overall Idea I am giving not 100% perfect ) the potions for these are 1) 33 2) 33.50 3) 37 4) 42 14) one compay has taken 10 million loan from a bank for a Interest rate is 10 % and base amount is 0.4% so how much they had paid monthly Emi ? they provideansews like 1) 100000 2) 114000 3) 140000 4) 104000 Remaing questions I not remember.

2309


What are the qualities needed by a software tester?

699


Explain compatibility testing with an example.

658


Explain the manual testing process?

724