It is a SQL question. Write a query to find top three
salaries in an EMP TABLE?

Answer Posted / ravi kumar battula

for max 3 salarie:

SELECT TOP 3 sal from( Select DISTINCT max(sal)ORDER By sal
DESC) Order by sal;

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can any one brief some detail on how the shared and action object repository utilized/implemented in a real time project. I already know how to make shared object repositor by saving OR as .tsr extension..I wanted the actual concept of implementation...couple of live examples will be highly appreciated. Thanks

1889


What are the different types of action?

545


How you create new action in qtp?

556


How to use userdifined environment variables.Once we created in Environment tab which is at File--> Settings-- >Environment-->Userdifined

1457


what is key word driven frame work ? why it is called like that ? what is the diference between keyword driven and data driven frame work ?

1541






How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s.

516


How the exception handling can be done using quicktest professional?

533


How to test background color and dynamic images during run time can you put the check point for moving objects?

1439


Please guide me release notes of Automation once scripts are completed

1451


What is the significance of “action 0” in qtp?

561


Hi, is it possible for recording shortcut key during record session? The application on which I am working is web based application. This application has several shortcut key associated with menu option. I have succesfully recorded all menu option but unable to record shortcut key.

1383


Difference between action & Reusable action?

676


What are the types of object repositories? Which one is you are using?

618


If I give some thousand tests to execute in two days what do you do?

572


Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...

1474