Interested to Buy Any Domain ? << Click Here >> for more details...
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 4347Post 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 a connectivity software?
How can you prevent abnormal termination of a python program?
What is data binding in angularjs and what is the difference between one-way and two-way binding?
Which database is good for large data?
When a person sends a message to someone with the Internet, there are steps that happen to the recipient to receive the message. How does the recipient know that the message was not edited by someone else?
What is averageif in excel?
What is the dynamic sql in oracle?
Interop Services?
What is the basic structure of a sas program?
Where is the iis config file?
What is mqseries channel?
Explain categories in wordpress.
What is cursor in mysql?
How would you change the location type in apo?
How many clients can I connect to an AP?
