SELECT & WHERE clause

The general syntax of the statement is:

The specification * means the query will resolve all columns. However, usage of * is discouraged in production because it makes queries less robust to catalog changes. Instead, a select_list can specify a subset of available columns or make calculations using said columns. For example, if Orders has columns named , price, and tax you could write the following query:

Rows can be filtered based on a clause.