Write a query to find second highest salary of an employee.
Answer Posted / ashutosh singh
select distinct(a.Sal) from emp a where &n=(select
count(distinct(b.Sal)) from emp b where b.Sal<a.Sal)
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Can you tell some good coding practices while automation?
What is a xpath?
How will you automate basic “login” functionality test cases for an application?
Please explain what is the difference between findelement () and findelements ()?
how to map requirements& test cases in quality center ???
What are the risks associated in automation testing?
If i am doing the automation of test suites in a project. Then what will be the system interfaces for that?? The tools I am using or something else... please help..!!
How can we make one test method dependent on other using testng?
Explain me what is testng and why is it better than junit?
Tell me how a text written in a text field could be cleared?
Explain me how do you send enter/tab keys in webdriver?
HOW CAN WINRUNNER AND TEST DIRECTOR CONNECTED TO THE DATABASE AND WHAT R THE OPTIONS?
What are the different types of an automation tool that you are aware of?
How do i startup with Remedy testing tool. Couldnot able to find any links for startup. Please help me to startup with this remedy tool.
Hi All! Am new to Selenium and would really appreciate your help writing test cases for the following scenario: 1. Manually create 2 logins User A and User B on say, orkut.com or facebook.com. 2. Have User A invite User B as a friend. 3. Have User B accept the friend request. 4. Have User A post a comment on his own profile. 5. Have User B post a reply to that comment. 6. Each User logs out of his respective account. 7. Do not use Selenium IDE. 8. Use Selenium RC and Java.