拼接字段 — 生成一个供应商报表,返回供应商名称和地址
select vend_name || '(' || vend_country || ')'
from vendors
order by vend_name
------------------------------------
Bear Emporium (USA )
Bear R Us (USA )
Jouets et ours (France )
select RTRIM(vend_name) || '(' || RTRIM(vend_country) || ')'
from vendors
order by vend_name
------------------------------------
Bear Emporium (USA)
Bear R Us (USA)
Jouets etours (France)
执行算术计算 — 汇总物品的价格(单价乘以订购数量)
select prod_id,quantity,item_price,
quantity*item_price as expanded_price
from orderItems
where order_num = 20008;
prod_id quantity item_price expanded_price
------- -------- ---------- --------------
RGAN01 5 4.9900 24.9500
BR03 5 11.9900 59.9500