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 2022Post 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 split a string in c++?
What are the applications of python?
Mention some ipad and iphone testing tools and their usability.
Who is the international champion in kabaddi?
what is the process for double acting cylinder pneumatic for 32' v/v
i want to know how a dg set run/works and what is strock and what difference in between two and four strock engine.
Can I stop a windows 10 update in progress?
Difference between bind parameter and lexical parameter.
How to load context variables dynamically from file/database?
How can we assign business system in runtimes?
What is a Thread dump? How will you take in unix/linux and windows ?
Which method returns the length of a string?
How can you set non-repudiation property?
How can we stop errors on display in a jsp page?
What is linspace in python?
