Check out a free preview of the full SQL Fundamentals course:
The "Filtering via WHERE clauses" Lesson is part of the full, SQL Fundamentals course featured in this preview video. Here's what you'd learn in this lesson:
Mike demonstrates that it is often undesirable to work with all tuples, or "rows," from a given table. Adding a WHERE clause to our SELECT query allows us to specify one or more criteria for filtering the result set.