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 1924Post 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 routes in apache camel?
What is the different type of users in sap?
Can you explain the difference between architecture followed in 10g & 11g?
How many types bend used in civil reinforcing
Why you want to change the job line (i.e. Secretary to Back-ed-process
What is google payday loan (spam) algorithms?
what is mean by c32/40s concrete class
What is hadoop role in an enterprise data hub?
How does ethylene oxide sterilize?
Explain fram control?
What is the difference between xhtml, html 4 and html 5? Which one do you use typically?
State and prove necessary condition for extreme values of the function f (x,y)
How to dump a table to a file with 'mysqldump'?
How do you test the script?
when u script reveiwing in which area u more concentrates?
