Select Basics

Select Alias Display

SELECT aliases name output columns for both copied and computed values.

highlighted = computed this step

Input table

Use invoice lines with product labels and unit prices.

Invoice lines\text{Invoice lines}
Invoice linesline_iditemqtyunit_pricel1notebook215l2pen38l3sticker42

Select query

Alias copied columns and alias a small computed price expression.

SELECT aliases\text{SELECT aliases}
SELECT aliases for displayselect line,product,price_with_feearity 3 rows 3InvoiceLinesarity 4 rows 3

Output table

The aliases become the output column names.

display names\text{display names}
Outputlineproductprice_with_feel1notebook20l2pen13l3sticker7