基础查询
1>.查询emp表中的入职日期列(hiredate),并按照时间的先后顺序列出;
SELECT hiredate FROM emp ORDER BY hiredate;
2>.查询工资大于1600的员工姓名和工资;
SELECT ename,sal FROM emp where sal>1600;
3>.查询员工号为7369的员工的姓名和部门编码;
SELECT ename,comm from emp where empno=7369;
SELECT hiredate FROM emp ORDER BY hiredate;
SELECT ename,sal FROM emp where sal>1600;
SELECT ename,comm from emp where empno=7369;