DQL: the SELECT statement

Sign in to read this lesson

Lessons are for learners and teachers with an account. Browsing the curriculum — subjects, strands and what each sub-strand covers — stays open to everyone.

• 8 sections of explanation, worked examples and diagrams
• 1 practice task with hints and worked answers
• A quiz that marks itself as you go
• Your progress kept across every subject you take

Other lessons in this sub-strand

1. What SQL is
2. SQL applications
3. Types of SQL statements
4. DDL: creating a table
5. DDL: altering and dropping
6. Keys and constraints in SQL
7. DML: inserting data
8. DML: updating and deleting
9. DQL: the SELECT statement
10. DQL: filtering with WHERE
11. DQL: sorting with ORDER BY
12. DQL: grouping with GROUP BY
13. Creating relationships in SQL
14. Creating an SQL database for community data
15. Reviewing SQL