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 2718Post 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 function of a content type in sharepoint?
What is a quick test professional?
When should you use a type cast?
What is 'stagflation'?
What is file extension of webservices?
Does google use spring framework?
What is linq in vb net?
Write a code to wait for a particular element to be visible on a page. Write a code to wait for an alert to appear.
comment calculer p/v a la bourse
Which of the following is not a valid declaration for main() a) int main() b) int main(int argc, char *argv[]) c) They both work
How does a server or client environment affect software testing?
How to show the sip keyboard in xna app?
What are the two types of m files?
absolute path gives the location a file or directory in reference to a rile directory while relative path is a path given file starting from another file. explain?
When the macros gets expanded?
