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 i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3448


Explain the etl program with few examples.

638


What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?

6640


What are the features of complex mapping?

737


Implementation methodology

1348






 Informatica Checkpoints

2944


Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

905


What is the difference between source qualifier transformations source filter to filter transformation?

708


Why do you use Mapping Parameter and mapping variable?

1377


What is a filter transformation?

672


How union transformation is used?

671


Write the program through which the records can be updated?

620


What are the components of Informatica? And what is the purpose of each?

694


I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.

1707


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1732