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 3178Post 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)
Can dynamic dashboards be scheduled?
What does ctrl shift t do?
What is BloomMapFile used for?
What are three soil science meanings of the term "clay"? : soil science
In testing of Cement the formula for water requirement for setting time is as below- Water required for setting time = NC x 0.85 The question is that what is the logic of 0.85 in this formula??
Explain how can the abundance and diversity of living beings in the tropical forests be explained?
What is python and explain some of its benefits?
Can I know about SAP for Insurance.
What is the use of dialect?
The xylem tissue that carries water is called?
How many kind of lookups can be made and how?
IF a vendors charges WCT @8.75% what is the rate of TDs to be deducted against that? & can we take the Input of it?
what are different types of electrical windings? i know the distributed winding ,concentrated winding etc but i want some detailed information, in what condition we will use distributed,concentrated windings what are the difference between them which is best, how induced emf changes by using different types of windings 20 hours ago - 1 week left to answer
What is java full form?
What are stuff and replace function?
