Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

Explain me how do you send enter/tab keys in webdriver?

955


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.

2007


How do you plan test automation?

1983


What is the purpose of deselectall() method?

1036


2. How you will collect a module from the version?

2424


How do we Test the C++ and Unix Application Using Automated Tool.

2480


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

2271


Do you know what is the difference between "type" and "typeandwait" command?

969


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.

1929


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.

1907


Tell me how can we find the value of different attributes like name, class, value of an element?

1015


What is a critical bug in a testing field?

1145


What criteria do you consider for automating a test?

1014


Tell us what is junit? And what is junit annotation?

1032


all clients are using at once if any problem raise?

2351