//计算字段在SELECT语句中创建,计算字段的创建应该在数据库服务器上进行,速度快
//拼接字段,以下拼接会在中间填充大量空格和列宽保持一致
SELECT vend_name + '(' + vend_country +')'//SQL Server等
SELECT vend_name || '(' || vend_country ||')'//Oracle,SQLite等
SELECT Concat(vend_name , '(' , vend_country ,')')//MySQL等
FROM venders
ORDER BY vend_name
//去掉多余空格,RTRIM函数去掉右边的所有空格,LTRIM去除左边的空格,TRIM去除左右两边的空格
SELECT RTRIM(vend_name) +'(' + RTRIM(vend_country +')'
FROM Venders
ORDER BY vend_name
//使用别名(导出列),用AS,别名是给字段命名,便于客户端引用,别名可用于重命名列
SELECT vend_name + '(' + vend_country +')'
AS vend_title
FROM venders
ORDER BY vend_name
//执行算数计算
SELECT prod_id,
quantity,
item_price,
quantity*item_price AS expanded_price
FROM OrderItems
WHERE order_num=2008//订单号为2008
//测试计算
SELECT 3*2
SELECT Trim(' abc ')
SELECT Curdate()//返回当前日期时间
SQL创建计算字段
最新推荐文章于 2024-07-18 15:45:25 发布