Writing a Basic Query

Writing SELECT Statements

When Sheila writes a basic query, two mandatory clauses in the SELECT statement syntax are required: a SELECT clause and a FROM clause.

The SELECT statement syntax is displayed. The SELECT clause specifies the columns that you want to display. The FROM clause specifies the tables that contain those columns.

SELECT [DISTINCT] * | column [alias], ...
FROM table;