SELECT
Retrieves data from a table.
Syntax
SELECT column FROM table;
Description
Specifies which columns you want and which table to fetch from. * brings all columns.
Example
Loading editor…
Expected output
Alex Linus
When to use?
Data reading — SQL's most commonly used command.
Common mistakes
- ⚠️ A semicolon (;) is required at the end of the command.