Write a query to find second highest salary of an employee.
Answer Posted / nitin shrivastava
SELECT MAX(esal) AS salary
FROM Emp
WHERE (esal <
(SELECT MAX(esal) AS Expr1
FROM Emp AS Emp_1))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are the disadvantages of Hybrid framework
What is Ticketing tool? Has it any other names? What is the purpose of this?
how to re-install QTP 11.0 trial version
How can you create html test report from your test script?
if i want to use different values in datatable with each iteration of for loop what would i do ??/
Explain some disadvantages to manual software testing?
if we are using an Engine (tool)..with that how to capture data from excel sheets and how to do automation with this plz answer any body for this question.?
How many test cases have you automated per day?
What COM Interfaces u r using in QTp While Connecting QC or TD? Or in QTP?Any body plz urgent...
hi every one this is ashok pls any one give answer me pls question is while testing with selenium after giving id user name and password , the inbox will be open , how to handle this one
Name some of the commonly used automation testing tools that are used for functional automation.
Tell us how to login into any site if it's showing any authentication pop-up for username and password?
What are the main differences between Loadrunner and QTP tools? Describe briefly a "real world" scenario that would make you use the first one versus the other? Thank you for your answers....
Tell me how can we find the value of different attributes like name, class, value of an element?
Could any one share scripts... where we can Parameterize radio buttons and Check boxes in Rational Robot.