ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
tip   To Refer this Site to Your Friends   Click Here
Google
 
Categories  >>  Software  >>  Testing  >>  Automation Testing  >>  QTP
 
 


 

 
 WinRunner interview questions  WinRunner Interview Questions
 Load Runner interview questions  Load Runner Interview Questions
 QTP interview questions  QTP Interview Questions
 Test Director interview questions  Test Director Interview Questions
 Rational TestSuite interview questions  Rational TestSuite Interview Questions
 Silk Test interview questions  Silk Test Interview Questions
 Automation Testing AllOther interview questions  Automation Testing AllOther Interview Questions
Question
It is a SQL question. Write a query to find top three 
salaries in an EMP TABLE?
 Question Submitted By :: Loki
I also faced this Question!!     Rank Answer Posted By  
 
  Re: It is a SQL question. Write a query to find top three salaries in an EMP TABLE?
Answer
# 1
select salary 
from (select salary from tablename order by salary)
where rownum < 4;
 
Is This Answer Correct ?    0 Yes 0 No
Harish
 
  Re: It is a SQL question. Write a query to find top three salaries in an EMP TABLE?
Answer
# 2
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;
 
Is This Answer Correct ?    0 Yes 0 No
Harish
 
 
 
  Re: It is a SQL question. Write a query to find top three salaries in an EMP TABLE?
Answer
# 3
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.
 
Is This Answer Correct ?    0 Yes 0 No
Ruchi
 
  Re: It is a SQL question. Write a query to find top three salaries in an EMP TABLE?
Answer
# 4
for max 3 salarie:

SELECT TOP 3 sal from( Select DISTINCT max(sal)ORDER By sal
DESC) Order by sal;
 
Is This Answer Correct ?    0 Yes 0 No
Ravi Kumar Battula
 

 
 
 
Other QTP Interview Questions
 
  Question Asked @ Answers
 
Can u explain about QTP framework ACS8
can we install qtp on server machine and do automation of application which is installed on client machine.If yes then how? If no then is there any other automation tool for this (client-server) senario.  2
When we use 'ERR' object to handle the exceptions in the script, do we need to include any statement in the beginning of the script..?? DST-Global-Solutions2
how to write scripts in QTP? Ordain-Solutions2
How to load a object repository in QTP during runtime? Virtusa1
Hi I have created a table in the MS access database. I want to access the table in this database through QTP. The code is given below. The code is not working.The following error is displayed "Data source name not found and no default driver specified". Any one can correct the code. Thanks in advance. Dim dbconnection, rs Dim ca, sname Set dbconnection = createobject("ADODB.Connection") Set rs = createobject("ADODB.Recordset") dbconnection.open "DSN = MS Access Database","", "" rs.open "select * from Research", dbconnection rs.movefirst If rs.EOF <> True AND rs.BOF<> True then ca = rs("order_number") sname = rs("customer_number") rs.movenext msgbox ca msgbox sname End If  1
What is the differnce between action & script Lehman-Brothers1
Hello friends can anybody tell me about the architecture of QTP with diagram of it.this architecture is same for any domain like ERP/Banking/CRM/Healthcare or it's different then please tell me.thanks Fidelity4
I want to open a Notepad window without recording a test and I do not want to use SystemUtil.Run command as well How do I do this?  9
How to get line numbers in your editor in expert view?  1
How i can change shared repository to per test repository in qtp  1
When we parameterise some field ex. Textbox is there any way that we can generate a specefic number of random values (For alphabetical values if possible) instead of manually entering values in the data table  2
how to test power point using QTP 8.2 ? WHAT ARE DIFFERENT METHODS TO RETRIEVE VALUE FROM APPLICATION DURING RUNTIME ? HCL2
Do we get any issues if we run the testscript on different browsers? what are the options we need to st in QTP? BirlaSoft1
How we can add actions in the test using QTP?  1
Explain the difference between smart identification and object identification withn clear example. please it is very urgent Wipro1
suppose by navigation i went from 1st page to 5th page write a script for coming from any page to the 1st page abd by executing where the page may be . it will come to 1st page give the code using gmail. give me mail id so that i can under this answer with out any doubt  1
Hi,The question is write a script for the following scenario. scenario:in a job portal i entered QTP 3yrs testing then click search button.then it displays results like Test lead bangalore (here is a checkbox). Test lead hyderabad check box so on... question is if test lead position in bangalore then checkbox shld be enabled automatically.. Thatavarti-Technologies2
how many wayes we do the parameterization?  1
What is the another extention name of library file.If that is exist than what's the differnce between them. Synechron1
 
For more QTP Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com