What happens to the records that don't meet the criteria when a filter is applied to a database?

When a filter is applied to a database, records that do not meet the specified criteria are excluded from the results returned by the query. These records remain intact in the database but are simply not visible in the output of the filtered search. This allows users to focus on relevant data without altering or deleting any underlying records. The original dataset remains unchanged, preserving all information for future queries.