It is a SQL question. Write a query to find top three
salaries in an EMP TABLE?
- 7 Answers
- 11565 Views
- I also Faced
- E-Mail Answers
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
what is the diff between manual test plan document and automation test plan doc.can u explain indetail.
Difference between test object and run time object?
What are output values and why they are used ?
What is recovery scenario manager? When you go for recovery scenario manager? Tell me one scenario were your used recovery scenario in your project?
There are 10 rows in the datatable. How can we fetch 2 rows and then skip 3rd row. After that, pick 4th & 5th row and skip 6th row. Please share code
When you open QTP, how many sheets you can see?
what type of values given to objects. EX::Set oBrowser=Description.Create oBrowser(“micclass”).Value=”Browser”
What is the Difference between test object and run time object?
What are the steps involved in recovery scenario wizard?
When ‘option explicit’ keyword is used in qtp?
Explain about the test fusion report of quicktest professional (qtp)?
How to suppress warnings from the test results page?
Where we can use the analog mode and where we can use the low – level mode?
How to carry out bit map check points in QTP
how do you parameterize search button from the website? the page is a single winobject and i have made a virtual object button of search button but search box can't be converted into a winedit and if we try to convert it into winedit the value we enter in a searchbox appears as numbers in the script so we arent able to parameterize.help!!!
