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 / ravi

I write this query and it run !!

SELECT max(salary) FROM Employee WHERE Employee.salary <
(SELECT max(salary) FROM Employee)


Plz reply if anyone having generic answer. :-)

Thanks

Is This Answer Correct ?    313 Yes 56 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What type of scenarios can be automated?

992


i have one answer from you that today the test cases are not stored in the database(SQL server 2005). But in automation testing where does the test case store? plz tell me... i have more confusion

2020


Program/pseudo code on FIFO? Input a string and make sure that output is in FIFO manner. Eg, Enter 'John Dave' as input and output should be 'John Dave' not 'Dave John'. (inbuilt functions like push, pop were given)

5436


can anyone suggest me any low cost tool that can support both Manual and Automation testing ?

1984


what we have done after display the result in openSTA result pane.in the sense that how we send the report,what we send in report,how to know that where is error.quickly tell me the answer...please

2204


Tell me what is the firefoxdriver, class or an interface? And which interface does it implement?

897


Once you identify the tool what would be your next steps?

1023


What is the difference between automation tools and management tools?

1039


Tell us what is the difference between @factory and @dataprovider annotation?

1102


Hi I need the following information about JMeter 1) How many(max) threads(users) can hit the website using Jmeter? 2) How long(in hours) can we run Jmeter for stress test? (Is there any “Memory full” issue if we run for long time?) 3)What typeof sampler to use for clicking on the link?

2575


Tell us what you know about table-driven testing?

981


Define sdlc in testing.

1037


I am testing a GIS based application so Can anyone tell me which automation testing tool is best for this application?

2905


Explain me what is testng and why is it better than junit?

1082


Explain load testing on websites?

1066