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
Explain me how do you send enter/tab keys in webdriver?
If I have given names to different DataTable columns and those column names are stored in a variable, then passing that variable to the datatable how can i Enter different values in those columns listed in that variable?? Please explain me with an example.I am not getting it.
How do you plan test automation?
What is the purpose of deselectall() method?
2. How you will collect a module from the version?
How do we Test the C++ and Unix Application Using Automated Tool.
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
Do you know what is the difference between "type" and "typeandwait" command?
I want a code for a following item in TSL Language. Look up a person in database, If not found, add person to the database.
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.
Tell me how can we find the value of different attributes like name, class, value of an element?
What is a critical bug in a testing field?
What criteria do you consider for automating a test?
Tell us what is junit? And what is junit annotation?
all clients are using at once if any problem raise?