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

i need department wise top 2 employees salary.which logic
i will use

Answer Posted / arun

Select top(2)* from table order by salary desc

Is This Answer Correct ?    2 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference among union, minus and intersect?

1002


How do you break a loop in pl sql?

1054


What are keys in sql?

1004


What are the differences between in and exists clause?

1112


What is the difference between view and stored procedure?

960


How to get help at the sql prompt?

1119


What does where 1 1 mean in sql?

1045


What are the most important characteristics of pl/sql?

1161


Do triggers have restrictions on the usage of large datatypes, such as long and long raw?

1167


Is it possible to create startup or shutdown trigger for on-schema?

1030


Is sqlite good enough for production?

997


Does mysql support pl sql?

1176


define sql insert statement ? : Sql dba

1033


what are myisam tables? : Sql dba

1033


What is sql keyword?

1006