ykd2020

1、使用别名 在列名和别名之间放上AS或者空格SELECT empno AS "Employee Number",ename name,(500+sal)*12 "Annual Salary" FROM emp;2、连接运算符 用两个竖线（||），把一个或多个字符串连起来SELECT ename ||'annual salary is '||(500+sal)*12 "Employee's Sa