Q73 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 MONTHS_BETWEEN (SYSDATE, start_date) <= 25
- (B). WHERE ADD_MONTHS(start_date, 25) <= SYSDATE
- (C). WHERE TO_NUMBER(start_date – SYSDATE) <= 25
- (D). WHERE MONTHS_BETWEEN (start_date, SYSDATE) <= 25
Answer: D