文件名称：使用串接操作符-SQL语言基础
文件大小：5.26MB
文件格式：PPT
更新时间：2024-05-15 13:24:47
SQL 基础
使用串接操作符 * SQL> SELECT ename||job AS "Employees" 2 FROM emp; Employees ------------------- KINGPRESIDENT BLAKEMANAGER CLARKMANAGER JONESMANAGER MARTINSALESMAN ALLENSALESMAN ... 14 rows selected. * SELECT ename||job AS "Employees" FROM emp; Concatenation Operator (continued) In the example, ENAME and JOB are concatenated, and they are given the alias Employees. Notice that the employee number and job are combined to make a single output column. The AS keyword before the alias name makes the SELECT clause easier to read.