I have a requirement to fetch data from DB with multiple condition.I need the records with Flag='Y' and 'N' as well and for Flag=N, only Max(MD_DATE) is required.
1) I need to Fetch FIRST_NAME, LAST_NAME, CITY, ZIP_CODE, CUSTOMER_ID, MANUAL_FLAG, DB_ACTIVE_FLAG
from the DB WHERE (DB_ACTIVE_FLAG='Y' OR DB_ACTIVE_FLAG='N') AND MANUAL_FLAG='Y' (Max(MD_DATE);
Could anyone help me on this?
Thanks in advance.