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 4471Post New Amex Informatica Interview Questions
What is the need of
how to maintain E-Commerce companies accounts
What is linq in vb net?
Explain load blancing alogarthims in cluster??
what are the major purchasing tables? List the transaction codes for them?
what are the Info Cubes developed in a sap project? Name them and what is the requirement
What are analogies for mitochondria?
What is mysap erp?
Explain the paragraph format in layout set.
Mention what are the data components used by Hadoop?
How do I publish a post on wordpress?
What is the use of HttpHandlers? When to use this?
Is lightning components replacing visualforce?
How will you fill the gridview by using datatable object at runtime?
I have a relay contact rated at 220v dc which is supplied with a 24vdc from the panel,for it to trip the dampers(24vdc).What if the application of the relay changes so that it should work at its rated 220vdc then will it work at 24vdc supply given or any other consideration needs to be taken .....