What is the difference between sorting and filtering
Answers
Explanation:
Data in a database can be sorted and filtered to make it easier to understand or work with. Sorting arranges data alphabetically or numerically in ascending or descending order. ... A filter in a database hides (filters out) unwanted records displaying only the records you want to see
Difference Between Sorting And Filtering:-
Sorting
Sorting arranges data alphabetically or numerically in ascending or descending order. For example, records in the incident report database are often referenced by Log ID. Sorting the records by Log ID makes finding a particular record easier when viewing the table. Sorting the records by the Operator field makes reviewing the incidents handled by each operator easier.
Filtering
Filter screens or separates out unwanted materials. A filter in a database hides (filters out) unwanted records displaying only the records you want to see. For example, you might want to see only reports for incidents that have been resolved. A filter allows you to do so quickly and easily.