Write a query to find second highest salary of an employee.
Answer Posted / mitul deshmukh
Select Salary
from Employee emp
where
2 = Select Count(Salary) from Employee emp1
Where
emp.Salary >= em1.Salary))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain some automation testing tools.
Where to maintain information like login, password and url?
What is junit annotation?
How do you choose which automation tool is best for your specific scenario?
Do you know what is a xpath?
Bug report formate in bugzilla
Explain what sikuli is?
Give some examples of priority – severity defect levels.
Kindly let me know how to setup JMeter for functionality testing of a Web application.. The apache help doc is good but i m little confused with it... :(
Explain what is the difference between findelement () and findelements ()?
22. Scenario: There are 1 to 100 numbers. Each number should be keep in the each column like from A column to Z column ie 1 to 26. From 27 to 52 should be in 2nd row in the excel sheet. This has to be continue till 100. How do you write Java program and what are various methods.
What is junit? And what is junit annotation?
how to use regular expression in Test Complete Functional tool
Tell us what automation tools could be used for post-release validation with continuous integration?
Can we prioritize tests in Junit. What is the sequence of execution in Junit?