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 4325Post New Amex Informatica Interview Questions
How to redirect stdout to a file in python?
Why You Have Chosen Sales Profile?
what curve and rateing would you use for a three phase 0.75kw motor?
What are the types of custom settings in salesforce? What is the advantage of using custom settings? : salesforce crm
What are the methods called when component is created or while inserting it to dom?
Is wordpress seo friendly?
Define cursor.
What is is External Quality Assurance (EQA) and Final Inspection (FI)?
What do you mean by adb?
What is the definition of a formula in excel?
What are the advantages of sap s/4 hana?
How to write text literals in oracle?
What’s a difference between apache web server and apache tomcat?
Explain nitrogen cycle?
When was the first motorway built in england?