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 2102Post 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 main purpose of excel?
No of ways of doing deployments?
how do you go about setting goals with subordinates?
What is routerstate in routers?
When workflow even fires?
How many types of streams are available in node.js?
How many scripts did you have?
what are the types of dimensioning?
What is an example of taxonomy?
Explain something about attribute?
What is the name of the java compiler?
What is the Surge suppresor? Why using in a UDB's and How it works?
Is uikit thread safe?
What type of pump is are commonly used in auxiliary boilers?
How many bytes is a url?
