SELECT & FROM clause review

SELECT first_column_name, second_column_name
FROM table_name
WHERE first_column_name > 1000;

*The column names that follow the SELECT keyword determine which columns will be returned in the results. You can select as many column names that you’d like, or you can use a * to select all columns. The order they are specified will be the order that they are returned in your query results.

*The table name that follows the keyword FROM specifies the table that will be queried to retrieve the desired results.

*The WHERE clause (optional) specifies which data values or rows will be returned or displayed, based on the criteria described after the keyword where.

Ready to go back to the lesson?