select * from emp;
select empno,ename,job from emp;
select job from emp;
select DISTINCT empno,job from emp;
select empno,ename,sal*12,sal/30 from emp;
select empno,ename,sal*12+5000 from emp;
select empno,ename,(sal+200)*12+5000 from emp;
select empno 雇员编号,ename 雇员姓名,(sal+200)*12+5000 年薪 from emp;
select empno 雇员编号,ename 雇员姓名,(sal+200)*12+5000 年薪,'¥' 货币 from emp;
select '编号是:'||'的雇员姓名是:'||ename||',基本工资是:'||sal 雇员信息 from emp;
select empno,ename,job from emp;
select job from emp;
select DISTINCT empno,job from emp;
select empno,ename,sal*12,sal/30 from emp;
select empno,ename,sal*12+5000 from emp;
select empno,ename,(sal+200)*12+5000 from emp;
select empno 雇员编号,ename 雇员姓名,(sal+200)*12+5000 年薪 from emp;
select empno 雇员编号,ename 雇员姓名,(sal+200)*12+5000 年薪,'¥' 货币 from emp;
select '编号是:'||'的雇员姓名是:'||ename||',基本工资是:'||sal 雇员信息 from emp;