拼接字段
SQL Server使用+号。
SELECT vend_name + '(' + vend_country + ')'
FROM Vendors
ORDER BY vend_name;
DB2、Oracle、PostgreSQL和SQLite使用||
SELECT vend_name || '(' || vend_country || ')'
FROM Vendors
ORDER BY vend_name;
MySQL或MariaDB使用Concat
SELECT Concat(vend_name, ' (', vend_country, ')')
FROM Vendors
ORDER BY vend_name;
RTRIM()、LTRIM()、TRIM()
RTRIM()去掉字符串右边空格
LTRIM()去掉字符串左边空格
TRIM()去掉字符串左右两边空格
SELECT RTRIM(vend_name) + ' (' + RTRIM(vend_country) + ')'
AS vend_title
FROM Vendors
ORDER BY vend_name;
使用别名
SELECT RTRIM(vend_name) + ' (' + RTRIM(vend_country) + ')'
AS vend_title #使用别名
FROM Vendors
ORDER BY vend_name;
执行算术计算
SELECT prod_id,
quantity,
item_price,
quantity*item_price AS expanded_price #使用算术计算和别名
FROM OrderItems
WHERE order_num = 20008;
注:SELECT语句为测试、检验函数和计算提供了很好的方法:
SELECT 3*2 #返回6
SELECT Trim('abc') #返回abc
SELECT Curdate() #返回当前日期和时间