I have table with ID,PRD_DT,PRD_FLAG,CUST_DT,CUST_FLAG I need to get max date and its corresponding flag for both the date columns. Ex:- 1A,10/3/2015,AC,10/3/2015,XY 1A,10/4/2015,AB,10/2/2015,XZ Output needed 1A,10/4/2015,10/3/2015,XY I have 100 million + in the table so avoid self-join...
2 1953Post New Amex Informatica Interview Questions
-
Amex Informatica Interview Questions (1)
- Amex SAS Interview Questions (1)
- Amex HR Questions Interview Questions (1)
- Amex SAP SD (Sales & Distribution) Interview Questions (1)
- Amex Electrical Engineering Interview Questions (1)
- Amex Banking Finance Interview Questions (1)
- Amex Audit Interview Questions (1)
- Amex Accounting General Interview Questions (1)
- Amex Call Centre AllOther Interview Questions (4)
- Amex English Interview Questions (1)
- Amex H1B Visa Interview Questions (1)
Does cp overwrite?
Explain delete actions & its types?
What is 'contingency fund'?
How does a Bandgap Voltage reference work?
Define linear regression?
Mention some of the major contributions made by you in your present and previous jobs:
How to integrate QTP with QC using VB Scripting? What are the prerequisites to connect with QC?
What is prefix of wordpress tables by default?
What kinds of test types are supported by selenium?
Explain what is ods (operation data source)?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How did you decide on a particular level of service?
what is controller in ember.js ?
what is the function of pragma directive in c?
Explain how to create a backup and copy files in jenkins?
