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 2283Post 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 role of document manager in oracle purchasing?
What is the difference between structure and class in c#?
what do you mean by recovery and speed parameters in define cluster command?
Name the different lookup cache(s)?
what r the checklist while installing a 380 kva DG set
What are the sizes of the Azure VM?
A 11KV, 1200 A breaker combination fixed in a cubicle for HT motor.Is normally for 11 KV motor fuse is using? if Yes, What range fuse is required?
what you mean by cross dunning
What do you understand by row chaining?
How can you select the exact color to match?
What is use of pointer?
HI, I AM SUNIL BISHNOI.I AM PREPARING FOR ISHRO ASTRONOTES EXAM.PLEASE TELL ME ALL ABOUT THIS.
What is URL Forwarding ?
Can you link excel to outlook?
What does the django field class types?
