What Does a Select Statement Look Like?

The five clauses of the SELECT statement

• SELECT
• FROM
• WHERE
• ORDER BY
• LIMIT

SELECT what fields I want to see;

FROM what table the data lives in; WHERE a logical condition exist; ORDER BY criteria for data order;

LIMIT only bring back first n rows;

I must have the first 2 keywords (SELECT and FROM) for the statement to make sense, all the others are optional

While not required the WHERE clause is really what makes this work