The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted.You only want to di
Posted: Sun Jun 11, 2023 3:54 pm
The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted.You only want to display details of rows where START_DATE is within the last 25 months.Which WHERE clause can be used?
A. WHERE TO_NUMBER(start_date - SYSDATE) <= 25
B. WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
C. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25
D. WHERE ADD_MONTHS(start_date, 25) <= SYSDATE
A. WHERE TO_NUMBER(start_date - SYSDATE) <= 25
B. WHERE MONTHS_BETWEEN(start_date, SYSDATE) <= 25
C. WHERE MONTHS_BETWEEN(SYSDATE, start_date) <= 25
D. WHERE ADD_MONTHS(start_date, 25) <= SYSDATE