--------------------------------------------------
--常量字段 ---
SELECT '常量字段'
--字段间计算---
SELECT FNumber,FName,FAge * FSalary FROM T_Employee
SELECT * FROM T_Employee WHERE FSalary/(FAge-21)>1000
--计算字段也可以在WHERE语句等子句或者UPDATE、DELETE中使用
--数据处理函数---
SELECT FName, LEN(FName) AS namelength FROM T_Employee WHERE FName IS NOT NULL --判断名字长度
SELECT FName, SUBSTRING(FName,2,3) FROM T_Employee WHERE FName IS NOT NULL --截取字符串
--字符串的拼接--
SELECT '工号为'+FNumber+'的员工姓名为'+Fname FROM T_Employee WHERE FName IS NOT NULL
SELECT * FROM T_Employee
WHERE Fsalary BETWEEN Fage*1.5+2000 AND Fage*1.8+5000
--联合结果集 UNION ----
SELECT FNumber,FName,FAge