A developer needs to implement a system audit feature that allows users, assigned to a custom profile named "Auditors", to perform searches against the historical records in the Account object. The developer must ensure the search is able to return history records that are between 12 and 24 months old.
Given the code below, which select statement should be inserted below as a valid way to retrieve the Account History records ranging from 12 to 24 month old?
A)

B)

C)

D)

Recent Comments (The most recent comments are at the top.)
I was wrong, sorta.
If you delete an AccountHistory record, ALL ROWS does nothing. They don't go into the recycling bin, and they aren't 'archived'.
However, if an Account Record is deleted that contains AccountHistory records, the AccountHistory records are marked 'IsDeleted' and can be queried using 'ALL ROWS'
The more you know 🌈
History records aren't archived - no need for 'ALL ROWS'