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

Answer Posted / pardeep kumar

Let I have EmpSal column in the tbEmployee table.


Select Min(EmSal) from tbEmployee where EmpSal IN(Select
Distinct Top 3 EmpSal From tbEmployee order by empsal Desc)


If this helps you then send me the mail at
pardeep_dhiman86@yahoo.co.in

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the hierarchy to use properties in descriptive programming

1496


How can you handle exceptions in qtp?

530


What is the syntax to call one script from another? And what can be the syntax to call one “action” in another?

694


Hi Friends, Would be great if you can provide the Model Question paper, Web site link or any reference s. Thanks & Regards, Byzoor,

1342


What is recovery scenario manager? When you go for recovery scenario manager?

586






hi can any body give me a script for creating a modularity or keyword driven framework..i am working as a qtp tester for 2 months but still i am not exposed to framework in my company

1422


Explain data driven framework?

575


Can you list some technologies that support qtp?

548


what is ODC and GDC?

7343


How to use parameterization in qtp?

618


Hi frnds, does anybody know if there is anything called "thin point" or something in qtp? thanks in advance.

2865


whenever U using QTP,Test Director, Why we using separate Bug tracking tool?

1562


What is the recovery scenario in qtp?

566


Hi All, we are using QTP Automation Scripts to test SAP. I recorded QTP Automation Scripts in English-based SAP GUI. Now we have to test a French-based SAP sytem and use the same scripts. The QTP scripts are failing when executed on the French-based SAP System due to Object Recognition Issues. What can we do? Do I re-record the scripts in the French-based SAP system?

2316


What is the difference between per-action and shared?

588