It is a SQL question. Write a query to find top three
salaries in an EMP TABLE?
Answer Posted / ravi kumar battula
for max 3 salarie:
SELECT TOP 3 sal from( Select DISTINCT max(sal)ORDER By sal
DESC) Order by sal;
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
How to Test the mainframe application?
What if recovery scenarios is also failed for identify the alert ? (We are handling unexpected popup through recovery scenarios but if still recovery scenarios also failed than what should be the approach)
what type of run time errors you get while you ar edoing rpg program?
An object is non standard object, i mapped it to standard object, eventhogh on mapping to standard object i cannot use the methods available on the standard object with the mapped object. How i can use those standard object methods with these mapped object. (((Note : dont tell that we can use virtual object as virtual object is to map nonstandard obj to standard obj)))
What are the different attribute used with regular expression?
How to handle the exceptions using recovery secnario manager in quicktest professional (qtp)?
What is CMMP and CMMH?
Brief the process of testing with UFT?
Hai anyone please "Explain about Framework in QTP?"
Why script error occur in between recording in qtp?
How is recording done when a application is over lapping the QTP application it gives a message object not recorded
What is test object?
write a script to verify the image path(src property) of the images which are in web pages.
HI Everybody, I am using QTP 9.2, I have a problem and hope everybody help me solve it. Now I need to use mouse wheel event to zoom in or zoom out in web client, but QTP can't catch this event. I look forward helping of everybody. Thank you very much.
Where is the resultset of a sqlquery (which is fired by rsobj.open sqlquery,xxxx,xxxx) stored ?