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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

write a query to get maximum salary from the employers table
without duplicates....kindly help me

Question Posted / sudheer113

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

Separate from a database, an information bazaar, and an information stockroom?

1090

Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2012

What is meant by query override?

1061

What is the use of source qualifier?

1139

What is status code in informatica?

1024

In warehouses how many schemas are there?

1074

What are junk dimensions?

1075

What is the commit type if you have a transaction control transformation in the mapping?

1034

What is informatica etl tool?

1001

What is the surrogate key?

1268

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

5680

Enlist the differences between database and data warehouse.

1127

What is expression transformation?

1107

What is the function of union transformation?

1137

How do you convert single row from source into three rows into target?

1158