emp(empid,empname,sex,salary,mgr,job,comm,deptid) 员工表(员工ID,员工姓名,性别,工资,上级员工编号mgr,职位,补助,部门ID)
grade(grade,lowsal,hisal) 工资等级表(等级,最低工资,最高工资)
dept(deptid,deptname) 部门表(部门ID,部门名称)
--e.g.查询员工的姓名,工资,工资等级
select a1.empname,a1.salary,a2.grade from emp a1,salary a2 where a1.salary between a2.lowsal and a2.hisal;
--e.g.查询雇员名,雇员工资,及所在部门名称,并按部门排序
select a1.empname,a1.salary,a2.deptname from emp a1,dept a2 where a1.deptid=a2.deptid order by a2.deptid;
--order by 排序
--group by 分组
自连接实例:
e.g.查询员工姓名,员工领导姓名
select worker.empname,boss.empname from emp worker,emp boss where worker.mgr=boss.empid;
e.g.显示员工”Ford“的领导姓名
select worker.empname,boss.empname from emp worker,emp boss