Write a query to find second highest salary of an employee.
Answer Posted / deepak falke
3rd highest sal from account :
SELECT TOP 1 Sal FROM account WHERE Sal IN
(SELECT distinct TOP 3 Sal FROM account ORDER BY Sal DESC)
order by sal
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
In what condition we cannot use automation testing for the agile method?
When will you automate a test?
What is tree view in automation testing?
If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.
WHAT'S THE TESTER'S ROLE DURING MIGRATION OF CODE FROM TESTING TO PRODUCTION ENVIRONMENT
Tell us how can we handle web-based pop-up?
What type of scenarios can't be automated?
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
I am surekha new commer for this site? I have some doubt's pls clarify it..... I finished my B.tech and S/w Testing Course Now iam searching for a job in Testing, I did not have any experience in real time projects. Any body can send me the sample Testcases,Srs,Matrix for Banking,ERP Projects etc.Here is my email id surekhai@yahoo.com
What are the main attributes of test automation?
What is Ticketing tool? Has it any other names? What is the purpose of this?
Do you know what is robot api?
What are the things that one should consider for selecting a project for test automation? For example, stability, etc.
Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.
Why do you prefer selenium automation tool?