SELECT Clause
Question
What does SELECT do in SQL?
Hint
SELECT is the most common SQL statement.
Explanation
The SELECT statement retrieves data from one or more tables. SELECT * FROM users returns all columns and rows. SELECT name, email FROM users returns specific columns. SELECT can include WHERE (filtering), ORDER BY (sorting), LIMIT (restricting count), JOIN (combining tables), GROUP BY (aggregation). SELECT does not modify data — it is read-only. The result is a result set (table-like structure).
Related Resources
Related Lessons
- SELECT
Learn SELECT.
Look up unfamiliar terms
A beginner-friendly glossary explains jargon in plain English — variables, functions, DOM, Promise, and more.
Decode error messages
Plain-English explanations of common errors — what they mean, why they happen, and how to fix them.
Build real projects
Apply what you learned by building guided projects with starter code and solutions.