课程第10次（2017-03-18星期六晚）

botang · 发表于 2017-3-18 23:53:04

上完1Z0-051第0/1/2章：关系型数据库，DQL和Where以及Order by
1Z0-051共12章（上完3章），1Z0-052共19章（上完3章），1Z0-053共21章（上完0章）
总共上完全部52章中的6章

select employee_id, department_name
from employees e, departments d
where e.department_id=d.department_id;
select * from employees e
where e.commission_pct is not null;
SELECT last_name||' '||job_id AS "Employees" FROM employees;
SELECT department_name || q'# Department's Manager Id: #'
|| manager_id
AS "Department and Manager"
FROM departments;
SELECT department_name || 'Department'||chr(39)||'s Manager Id: '
|| manager_id
AS "Department and Manager"
FROM departments;
select * from user_tab_columns
where table_name='EMPLOYEES' ;
SELECT employee_id, last_name, salary, manager_id
FROM employees
WHERE manager_id not IN (100, 101, 201, null) ;
select * from employees
where employee_id not in ( select manager_id from employees where manager_id is not null);
SELECT employee_id, last_name, salary*12 annsal
FROM employees
ORDER BY first_name;
SELECT last_name, department_id, salary
FROM employees
ORDER BY department_id desc, salary DESC;
--
SELECT employee_id, last_name, salary, department_id
FROM employees
WHERE employee_id = &s_1 ;

复制代码