Answer / pardeep kumar

In the Above post i have given top third salary from the
table.
Now the Query for the top three salaries.

Select distinct Top 3 EmpSal from tbEmployee order by
EmpSal Desc.
Pardeep Kumar

Answer / harish

Sorry ..above one is to find lowest threee...

This is for highest 3 salaries -

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

Answer / ruchi

In MYSQL:
select salary from (select salary from tbl_salary t order
by salary desc) as u limit 3;

u is the table alias,which is a must.

Answer / saranya

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

Answer / 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

Answer / harish

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

Answer / ravi kumar battula

for max 3 salarie:

SELECT TOP 3 sal from( Select DISTINCT max(sal)ORDER By sal
DESC) Order by sal;

Hi What are re-usable actions in QTP? -Thank You

5 Answers   Siemens,

How will u integrate oracel with QTP?

2 Answers   Microsoft,

What are the Automation Limitations??

1 Answers  

In a shared Object Repository in QTP if some object is changed how can the other script which is using the same object can be known

6 Answers   iGate,

What is Descriptive Programing? In which cases, we will go for descriptive programing?

2 Answers   CTS,

To which environments does a QTP support?

1 Answers   Crea,

How to add Dynamic Objects to Object repository?

5 Answers  

I need Major Help with a Script I recorded in QTP 9.5. I am recording scripts for a Web-based application(s) I have all the URLs for each application in Excel spreadhsheet so that QTP can pull that particular application from the spreadsheet and run it. The problem is QTP isn't recognizing one particular URL so when I hit run in QTP to run this script it opens the internet Explorer but isn't open the URL I have in the Excel spreadsheet. I've retyped the URL and still QTP won't open this Particular one for some reason. The site its self is working fine but for whatever reason QTP won't open it. How do I resolve this? I have a deadline of next Friday the 7th to complete this task so please help me in any way you can. Thanks in advance

0 Answers  

Could anyone help me for the below scenario: i am using the descriptive programming for my account, in which we have to generate the contract in the MS-word. when i generate this doc, we need to click on enable macros to continue further. but i am unable to make qtp to click on this. if anybody faced the problem like this??? pls help to get it resolved? Thanks in advance

0 Answers  

Ex : some mail name with surname Email id's there that is string fetch the particular surname only how to get particular surname all emails

1 Answers   Infosys,

Explain in brief about the quicktest professional (qtp) automation object model?

0 Answers  

Diff b/w Test Design and Test case design? What is the Design Review's and Code Review's. When will you conduct tese reviews?

1 Answers