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...

how to get top two salaries from employee tables

Answer Posted / shiva - e-softsys

SELECT MIN (SALARY) FROM EMP WHERE

SALARY IN (SELECT DISTINCT TOP 2 SALARY FROM EMP ORDER BY
SALARY DESC)

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Tell me a critical defect in which your Client,PM,PL appreciate on you

2213


What do you mean by Unit Testing, Integration Testing, System Testing, and User Acceptance Testing and when do you do them?

8192


What is the quality process is following in your organization.

2278


Can you explain the elementary process?

1220


What are the RBI rules has to follow by a bank for online precesseing. ?

2207


What’s the difference between verification and validation in testing?

1174


What is a ‘test plan’?

1246


How do you go about testing a project?

2014


What do you do (with the project tasks) when the schedule fails?

3154


what are your thoughts on SPRINT duration

2185


Are there more defects in the design phase or in the coding phase?

1473


Changes and enhancements to system?

2140


How do u determine,what to be tested?

2124


How do you scope, organize, and execute a test project?

2298


I have interview on Guide wire testing. If you please share me.

911