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 get maximum salary from the employers table
without duplicates....kindly help me

Answer Posted / sudheer113

MAX(SAL) will not give duplicate records in a single group

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Write the unconnected lookup syntax and how to return more than one column.

1147


What is main use of mapplet?

1176


Explain incremental aggregation in informatica

1182


suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?

7365


what are the best practices to extract data from flat file source which are bigger than 100 mb memory?

2412


What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?

1249


where to store informatica rejected data? How to extract the informatica rejected data?

1053


explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?

2197


What is a filter transformation and why it is an active one?

1015


how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?

2504


What is the function of look up transformation?

1172


Can one use mapping parameter or variables created in one mapping into any other reusable transformation?

1138


What are the databases that informatica can connect to windows?

1095


How can informatica be used for an organization?

1271


What is a passive transformation?

1151