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
Explain how qtp identifies object?
How do you capture tooltip using QTP?
Explain the concept of object repository and how quicktest professional (qtp) recognises objects?
How QTP identify the system time that's changes every seconds?
how u will evaluate the tool for test automation?
Explain how you can find length of array in qtp?
Hi All, I have QTP installed on my machine but the application under test is on remote machine. I need to automate the scenarios which consist of automatically enter the remote machine through IP address ,record the application in remote machine and run it also when played. Can some one tell how to record the application in remote machine.
Could you please any one give code for the following ? Scenario : Suppose a excel file contains 10 records and earch have 5 fields. how can i input this excel file for datadrive wizard ? Please explain
Hi, Can we open a test in qtp10 which is saved in qtp 9.2?
What is the significance of “action 0” in qtp?
What is recovery scenario in qtp?
If I am scripting Web-based Surveys using QTP that open up differently but at the exact same point require a username and password can I automate that username and password for all the surveys some how using QTP?
is it possible to add sheets to excel at runtime
what difference between runtime object and text object and what property they have. whether they have same properties or different properties.
What is standalone database?