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

How do you update the records with or without using update strategy?

1077


Is it possible to create multiple domains on a single Informatica server?

1199


What are the popular informatica products?

972


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

7308


Which version configuration tool used in ur project?

3203


How can you validate all mappings in the repository simultaneously?

1318


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

2203


What does update strategy mean, and what are the different option of it?

1058


What is a shortcut and copy in Informatica and how two are different with each other?

1160


Write the advantages of partitioning a session?

1234


What is a snowflake schema?

945


What are the components of the workflow manager?

1098


How we can create indexes after completing the load process?

1130


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

1069


What are the features of complex mapping?

1116