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

Answer Posted / saranya

select salary from(select salary from tablename order by
salary desc) where rownum < 4

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In order to select an automation tool for automating ur application, what r the things u need to consider? For eg i will go for automation; 1) When there is a lot of retesting and regression testing. 2) Return on investments. 3) Whether the tool supports the appln. 4)--------------, etc. Pls give me more number of points because my answer did not satisfy the interviewer. Very urgent pls

1439


Where to use function or action?

664


What is optional step in qtp? How you can add optional step in qtp?

524


Explain more about the Test Fusion Report of QTP?

598


How Can I find the least value in a bunch of variables using qtp.. E.g.:- A = 210, B = 212, C = 60, D = 111 I don’t want to write bunch of lines for this…. Is there a way to get the result in one line…..

1607






How to export quicktest professional results to an .xls file?

564


What is action split and the purpose of using this in qtp?

527


What are the advantages of parameterization ?

587


How we can import data from database?

643


Can any one explain me what is the procedure to connect the remote desk by using QTP 9.2 ?

1511


when to start the automation?

1471


What is the quicktest professional testing process?

519


Explain how you can find the absolute value of the number in qtp?

639


Is the qtp course will help to create a virtual object?

1510


In a flight window we have to enter the name and meal request for every passenger.In that window if we give Total passengers=1 then the Psngr1 name field and psngr1 meal request field will reflects.if we give Total passengers=2 then Psngr1 name field and psngr1 meal request field,Psngr2 name field and psngr2 meal request field will reflects and so on.if total psngrs=100 then will we capture all the fields for the psngrs to Automate the app how we can handle this scenerio thru Descriptive programming?

1441