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
The STORES table has a column START_DATE of data type DATE, containing the date the row was inserted.You only want to di
-
- Site Admin
- Posts: 899559
- Joined: Mon Aug 02, 2021 8:13 am