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 3431Post 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)
What are the technologies that are supported by hibernate?
What is a syntax in c++?
Describe the venus atmosphere 14 how far from earth, is the moon?
Can singleton class be serialized?
How do unix sockets work?
i have applied for junior engg. signal II please send me questions papers for it
Give main differences between "Truncate" and "Delete".
What are qualitative specifications under master inspection charactertics?
What is an app in salesforce and what are the types of apps?
How can I protect an excel file (and associated code) from unauthorized copying and/or create time limited functionality?
how to track no of users logged in?
What is a background work item ? Are they displayed in the business workplace?
Contrast between an interface and abstract class?
What is open and close posting periods?
Is it ok to delete downloaded program files?
