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

How to find array size in qtp?

580


What are the data types in qtp?

663


can any body plz help by sending the qtp docs and qtp ppt's? this is my mail id:murali.padeti@gmail.com

1756


Explain advantages and disadvantages kdf?

516


How to test login module with different username and password by using data driven testing in QTP?

604






can i compare two databases using QTP ?

1875


Is there any pdf or online book for QTP Scripting? Let me know more about QTP Scripting.

2423


Step 3&4 are repeated until an the object in recognised uniquely.

1518


What is the default object synchronization timeout in qtp?

639


Define object spy ?

557


Describe function procedure in vbscript.

549


how we implement share object repository in QTP 9.0 without using quality Centre , Explaine in brief

1536


What is checkpoint in qtp?

550


What is the syntax to call one script from another?

535


What environment does qtp run in?

615