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 3840Post 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 elements of ms word?
What are the different types of bio technology?
1. Why is the speed of shunt motor practically constant? 2. Why dc series motor use to start with heavy loads? 3. advantages & disadvantages of separately excited generator over self excited generator?
What is a Pivot?
How to make object serializable in java?
Tell me how to unlock the background in photoshop?
How do I change divx to vob?
How many bytes we can send to apple push notification server in iOS operating system?
What is Green Channel?
What is the materials of cotter joints?
In tm, if a group of employees gets 10 days of annual leave, what will be the time evaluation status? : sap abap hr
Would we be able to invigorate our Power BI reports once transferred to a cloud?
please I wont know how to calculate the vector group for power transformer ZNyn11 best regard.
Can we Put "TAX INVOICE" in the sale in Transit (E1) Invoice.
Write a command to get actual path of a servlet to the server?
