Almost every task in SQL begins with asking the right question of your data. This module is about reading it: choosing exactly the columns you want with SELECT, removing duplicates with DISTINCT, and renaming output with aliases.
From there you'll narrow results down with WHERE, combining conditions using AND, OR, and NOT and matching sets and ranges with IN and BETWEEN. You'll also learn pattern matching with LIKE, and how to put results in the right order and keep only the rows you need with ORDER BY, LIMIT, and OFFSET.
Work through the lessons in order, then continue on to Functions & Expressions.
A focused walkthrough of sorting query results with ORDER BY and keeping only the rows you need with LIMIT.
Part of a numbered SQL tutorial series: sorting rows in ascending and descending order with ORDER BY, including sorting on multiple columns.
A short MySQL lesson on ordering results and paging through them with LIMIT and OFFSET.
Amigoscode's beginner SQL tutorial: writing queries to retrieve data with SELECT and filtering rows with WHERE, with plenty of hands-on practice.
Traversy Media's practical MySQL crash course, covering the everyday statements for selecting, filtering, sorting, and limiting data.