SQL 必知必会第七课 创建计算字段
select concat(vend_name, '( ',vend_country,' )') from Vendors order by vend_name;
## 拼接供应商名,左括号,供应商国家,右括号
select concat(vend_name, '( ',vend_country,' )') as vend_title from Vendors order by vend_name;
select prod_id,quantity, item_price from OrderItems where order_num = 20008;
select prod_id,quantity, item_price, quantity * item_price as expanded_price from OrderItems where order_num = 20008;
##Challenges
select vend_id, vend_name as vname, vend_address as vaddress, vend_city as vcity from Vendors order by vend_name; -- 1
select prod_id, prod_price, 0.9 * prod_price as sale_price from Products; -- 2
注意点
-
若想要有空格,需要加空格字符,不用trim函数去空格
-
别名还可以用来修改合法的字符名