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

Can we override a native sql query within informatica?

1034


How can we use batches?

1025


Explain lookup transformation source types in informatica

1096


Explain target update override in informatica

1122


What is a stored procedure transformation?

1049


Explain the scenario which compels informatica server to reject files?

1162


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1995


How do you load alternate records into different tables through mapping flow?

1850


How can you increase the performance in joiner transformation?

1183


Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?

2335


Is it possible to define a single node as a Gateway node as well as worker node?

1118


in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records

2234


How you can differentiate between connected lookup and unconnected lookup?

1058


What is rank transformation?

987


Write the different tools in the workflow manager?

1058