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 3455Post 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 does the minimumprefixlength property of the autocompleteextender control do? : asp.net ajax
How can we create a custom "twitter handle" field in a registration form?
What is mousehovertime?
What happens, if you have stored a password in a dataflow and create a template out of it?
what shows avribiations related to bearing blocks
What do you understand by a routed event and what are its types?
Explain basophils?
What is php and how do you use it?
List out the tags those are mostly used in html?
Explain the architecture of Hadoop Pig?
Explain basic code snippet of jsx with the help of a practical example?
What are the ways in which the file can be detected as being uploaded or not?
What will be the maximum number of index per table?
mention any other commands other than q db, q log?
What does the graceful restart option in apache do?
