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 2161Post 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 business data catalog or bdc ?
What is concatenating?
is there any current and voltage drop on liquid resistance starter water/soda tank ?
Where can I learn python for free?
What storage types are allowed by openstack compute?
please send me the previous question papers of ntpc writen test for ece
What is sap hybris billing?
iam B.E 1year student,actually i have a habit i.e anything to think pratically but always iam in confusion what i have to do
What is Mapper? How can we compress Mapper output in Hadoop?
How can we identify User exits in our screen?
How biological neuron model is different from artificial neuron?
Write a code to generate divisors of an integer?
why and how static variable retain their value after postback form ?
Will c# 3.0, vb.net 9.0, atlas, or linq be included in the .net framework 3.0?
How do you update a table of contents?
