Oracle 数据库 SQL 语句示例：更新、删除、查询和排序

'使用 Oracle 数据库语音更新 7369 号员工的工作和工资使其与 7876 号员工相同。

' 'UPDATE employee SET job = (SELECT job FROM employee WHERE empno = 7876), sal = (SELECT sal FROM employee WHERE empno = 7876) WHERE empno = 7369; '

'删除部门号为 10 的部门。

' 'DELETE FROM department WHERE deptno = 10;'

'把 Smith 的部门号更新为 70 呢

' 'UPDATE employee SET deptno = 70 WHERE ename = 'Smith';'

'如何显示工资高于 3000 的员工

' 'SELECT * FROM employee WHERE sal > 3000;'

'如何查找 1982 年以后入职的员工

' 'SELECT * FROM employee WHERE hiredate > TO_DATE('1982-01-01', 'YYYY-MM-DD');'

'如何显示工资在 2000 到 2500 之间的员工

' 'SELECT * FROM employee WHERE sal BETWEEN 2000 AND 2500;'

'如何显示每个雇员的年薪

' 'SELECT ename, sal*12 as annual_salary FROM employee;'

'如何显示部门号为 10 和 20 的员工信息

' 'SELECT * FROM employee WHERE deptno IN (10, 20);'

'如何显示首字母是 S 的员工姓名、工资

' 'SELECT ename, sal FROM employee WHERE ename LIKE 'S%';'

'如何显示第三个字符为大写 O 的员工姓名和工资

' 'SELECT ename, sal FROM employee WHERE ename LIKE '__O%';'

'查找工资高于 1000 或者岗位是 MANAGER，同时名字首字母为 J 的员工信息

' 'SELECT * FROM employee WHERE sal > 1000 OR job = 'MANAGER' AND ename LIKE 'J%';'

'按工资从低到高的形式显示雇员信息

' 'SELECT * FROM employee ORDER BY sal ASC;'

'按部门升序、工资降序排序

' 'SELECT * FROM employee ORDER BY deptno ASC, sal DESC;'