别名 (1)别名 select sal,comm,sal + ifnull(comm,0) as money from emp; (2)as关键字可以省略 select ename name, sal,comm,sal + ifnull(comm,0) as money from emp;