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

hi this is charan,
select e1 *from employees e1
where 2>
( select column(distincte2.sal)
where e2.sal>e1.sal )

Is This Answer Correct ?    4 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Anybody having documents and URLs about BFSI domain...Please share..it is really urgent

2372


What is Cyclometric testing?

2328


what is the relation between all tabs in quality center & explain the testing process in quality center with tabs?

2028


what is meant by application server and its functions?

7034


Can you explain regression testing and confirmation testing?

1137


what technical problem u face in your module please tell what is it mean its any bug or anything else i want ans give any example which ever modul u r working for u can give me any example

2308


What is a failure?

1242


what is a data guidelines?

2233


I have 6 months experience as project tarine and one and a half year experience as software engineer.Should i write taht my total experience id 2 years.

1947


how to indentify memory leakages after the build

2127


What is concurrent user hits in load testing?

1430


There are some features to improve the performance of a Product. What are those factors?

1997


how to connect your project in database?

2042


Have u ever done testing related to a database,give examples to support u r answer.

2148


I have 2 yr Localisation testing exp now i want to job in MNC My manualtesting knowledge+2 yr exp sufficiant for in MNC

2005