SELECT

SELECT is how you read data out of a table.

Source data — Pattern 1: Basic Data Retrieval

All queries run against the shared employees table (see schema.sql).

SELECT — source table 1

What it does

SELECT is how you read data out of a table. SELECT * means "every column" — quick for exploring a table, but in real applications it's usually better to name columns explicitly (see topic 2) so the query doesn't break or slow down when the table gains new columns.

Problem

Display all employee details.

SELECT *
FROM employees;

Result

SELECT — result 2

SQL · Pattern 1 — Basic Data Retrieval