Filtering and sorting

6 lessons in the SQL course.

Full SQL course · Search this topic · Programming

• Filtering with WHEREUse comparisons in WHERE to keep only matching rows.
• Combining ConditionsBuild precise filters with AND, OR, NOT, and parentheses.
• Searching with LIKEMatch simple text patterns with LIKE and SQL wildcards.
• Sorting ResultsSort query results by one or more expressions with ORDER BY.
• Limiting ResultsReturn a small, predictable slice of a result set.
• Working with NULLRepresent missing values and test them correctly.