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 3900Post 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 procedure to display the information of search engine?
What are limitations of DBSCAN?
Mention the steps to optimize the Drupal website?
What is java panel swing?
What is the difference between scrolling a table horizontally and vertically?
why assets are shown at their historical cost price but not at their current price bcoz we are following historical cost concept. but this will not reveal correct financial position of the business.give reason
What are dependent fields?
What is the use of safe mode in android?
What is 'gap insurance'?
How to apply a custom master page?
What are pointers really good for, anyway?
Which columns go to the fact table and which columns go the dimension table?
Tr. Wiring for calibration.
Why we use extension method in c#?
How do you generate form 24q ?
