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 1983Post 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 is the right technique to brush?
Tell me does Angular use the jQuery library?
Research serves a single purpose-that of providing information to assist marketing manager to make better decisions? Elaborate this statement.
What is synchronously and asynchronously?
How to add local jar files to a maven project?
What is the meaning of the enq command?
How will u write page object models and data driven model.
How can I make a time delay in python?
Can you tell which of the following where clauses is faster?
What is the target antigen for colon cancer?
What is dependency injection?
What are Namespaces?
How to break infinite loop?
Is there any attempt system for microsoft technology papers?
What is the full meaning of mysql?
