What enables us to view data from a table based on a specific criterion?

This is typically done using WHERE or HAVING clauses in the SQL utilizing the various structures (IN, BETWEEN, EXISTS, expression operators, etc.)