-
concatenating fields
- SELECT Concat(vend_name, ' (', vend_country, ')')
- FROM vendors
- ORDER BY vend_name;
-
using aliases
- SELECT Concat(vend_name, ' (', vend_country, ')') AS
- vend_title
- FROM vendors
- ORDER BY vend_name;
-
performing mathamtical calculations
- SELECT prod_id,
- quantity,
- item_price,
- quantity*item_price AS expanded_price
- FROM orderitems
- WHERE order_num = 20005;
- Operator Description
- + Addition
- - Subtraction
- * Multiplication
- / Division
|
|