SQL SELECT

Definition: The SELECT statement reads data from a table. You list the columns you want, then say which table to read from with FROM.

Example 1 — pick specific columns

SELECT CustomerName, City
FROM Customers;

Example 2 — all columns with the * wildcard

SELECT * FROM Customers;

The asterisk * means "every column".

Example 3 — read from another table

SELECT ProductName, Price
FROM Products;

💡 Tip: ask only for the columns you actually need. SELECT * is convenient while exploring, but in real applications listing columns is faster and clearer.