Include Deleted Clause
Salesforce allows you to include All Rows clause when you run the query in Apex language context. This clause shows
all records, including deleted/archived records. This clause doesn't work outside of the Apex Language context.
Brobench supports similar clause include deleted, which runs the query SOQL to include deleted and archived records.
option. This clause must come last after all other clauses, including any limit and offset clauses
Note that you can also query to show deleted records by executing the query using
Execute with Include Deleted/Archived option. See Execute Other for more information.
For example.,
select Id, Name from Account
include deleted