What is the purpose of filters in a database?

Answer 1

Filters in database reduce down the records you see, by finding ones that meet certain criteria. So if you had a list of people and their date of birth you could impose a filter to just show ones born after a certain date. If you had a list of companies and their profits or losses you could use a filter to show just the ones that made a profit. If you had a list of products you could show ones that were of a particular category. Filtering does not delete records, it just shows ones that meet certain criteria. The filters can be turned off so you see all the records again.