南师大GIS考研数据库2018年第三题

题目

解答

1. 第一问

   	update EMP
   	set sal = sal+500
   	where deptno
   

2. 第二问

   	select ename, sal, grade //把所需要的属性投影出来
   	from EMP, SALGRADE  //两个表进行笛卡尔积运算
   	where sal<=hisal and sal>=losal //选出符合条件元组
   

3. 第三问

   	 foreign key(deptno) references DEPT(deptno) on insert on action
   

4. 第四问

   	select (avg(EMP1.sal) – avg(EMP2.sal)) as result
   	from (select top 10 * from EMP as EMP1 order by EMP1.sal desc,
   	select top 10 * from EMP as EMP2 order by EMP2.sal asc)