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
Do you know how can we make one test method dependent on other using testng?
Tell us how can you find if an element is displayed on the screen?
Tell me what is the testng.xml file used for?
how to test an webbased application?
Tell me what kind of tests should not be automated?
What is the major difference between Acceptance test , Functional test , Usability test and Performance test with special reference to auotomotive domain
It is a 30 days project & the client is in Singapur and we have to submit daily report regarding 1) What are the completed works, 2) What are the Pending Works ,3) Work planed for next day. You are free to assume regarding the project. can anybody help me to write an email to the client or Senior person who is staying in abroad
Where will you maintain information like url, login, password?
Tell me how could the web element attributes be inspected in order to use them in different locators?
List out some of the automation tools which could be integrated with selenium to achieve continuous testing.
What is the difference between close and quit command?
Tell me how would you test your own element locator?
write a programme to insert into elements in array?n finding duplicate characters in given sting?
How to capture Dos Promote data in text file? in that how to find particular String ( window )? in VB scrpting
What is the purpose of deselectall() method?