Write a query to find second highest salary of an employee.

Answer Posted / aj

select * from emp A where 1=(select count(*) from emp B
where A.SALARY < B.SALARY)

Is This Answer Correct ?    12 Yes 9 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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.

1489


Explain how to perform load-testing?

595


How is Jmeter tool very useful in projects when it does not have features like online monitoring,WAN emulation,caching like other performance tools.

1944


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

1583


What are the advantages of the automation framework?

523






Explain me what the webdriver supported mobile testing drivers do you know?

576


How did you use automating testing tools in your job?

1533


What are the things that one should consider for selecting a project for test automation? For example, stability, etc.

1559


hello frnds this pooja i hav started working on selenium with java ecllipse frnds could u tell me how to handle popup windows and security alerts i m jst trying and couldn't do anything plz help

1594


Have you completed the cps exam? Which one?

536


4. How we implement Winrunner,in our project?

1979


What is test automation or automation testing?

524


Explain what sikuli is?

591


Tell us what methods of robot class do you know?

506


why should we choose VSTET(Visual Studio Team Edition for Testers) and not QTP?pleas give me the reasons for "WHY" we have web and client server app, supports power builder and on windows OS so this is the background of tech and envir things we have and now VSTET is good to use or not? if "NO" then tell me why

1774