heidi_l的博客

原创 mysql-查询练习

select * from emp; select empno,ename,sal from emp; select distinct job from emp; select ename, job,sal*12 as income from emp; select ename, job,(sal+300)*12 as 年薪 from emp; #要求查询出基本工资高于1500的所有雇员信息 se...