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

SELECT MIN(SALARY) FROM EMP WHERE SALIN(DISTINCT TOP2
SALARY FROM EMP ORDER BY SALARY DESC.

OR
SELECT TOP 2 SALARY FROM EMP ORDER BY SALARY DESC.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Build with fixes has been deployed on QA environment if asked by your manager to reproduce how can you reproduce the issues? (by using the previous build) Can you access the previous build? If so ,what are the tools or how can you access?

2174


Can some one help me writing a manual test case for email applications like yahoo i need for www.everonn.com

2073


What are the different types of software testing?

1258


What are the main key components in web applications?

1284


write a testing stratgy \ approach for a product that you are use every day (e.g gmail, out look etc)

1971


can anyone tell me the scenarios for online banking transaction ?

2193


What do you understand by usability testing?

1160


What's the difference between system testing and acceptance testing?

1313


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

2139


wat if fiddler and how it is used in tesing an application. please explain with a real time scenario

2246


MS Paint

2151


How to test the search functionality.For example in naukri advance search is there.how ca i test that page.

2211


How could we start writing testcases without having the FRS,BRS Docs? My Project has some docs that are related to explain the operations which will be done in the application. It is deployed in UAT server and is a maintainance project. Tell me some technipues or best way to provide the quality to application?

2250


What impact ratings have you used in your projects?

1163


What are the main key components in web applications and client and server applications? And explain the differences between them?

1281