SQL · Pattern 1 — Basic Data Retrieval
SELECT Specific Columns
Listing columns by name instead of * returns only what you need — less data moved over the network, and a query that keeps working even if unrelated columns are added to the table later.
Source data — Pattern 1: Basic Data Retrieval
All queries run against the shared employees table (see schema.sql).
What it does
Listing columns by name instead of * returns only what you need — less data moved over the network, and a query that keeps working even if unrelated columns are added to the table later.
Problem
Display employee name and salary.
SELECT first_name, last_name, salary
FROM employees;
Result
