编译原理_第二版(龙书,紫龙书)课件.ppt

文档介绍：3 SQL
3-8
a.
Select count(*) from license a
Where exists(select 1 from owns b,person c where = and = and =‘John Smith’)
b.
Update license set damage_amount=3000 where report_number=‘AR2197’ and car=‘AABB2000’
3-9
a.
select employee_name from works pany_name=‘First Bank Corporation’
b.
select ,
from employee a,employee b
where = and
exists( select 1 from works c,works d, company pany f where = and = and pany_name=pany_name and pany_name=pany_name and =)
3-9
c.
select ,
from employee a,employee b
where = and = and
exists( select 1 from mamages c,manages d
where = and = and =)
d.
select employee_name from works a
where > (select avg() from works b where pany_name=pany_name group by pany_name )
e.
pany_name from works group pany_name having sum(salary) <= all (select sum(salary) from works group pany_name)
3-9
e.
pany_name from
(pany_name,sum(salary),rownum from works group pany_name order by sum(salary))
where rownum=1;
pany_name from
(pany_name,rank() over order by sum(salary) rank
from works group pany_name )
where rank=1;
3-10
a.
update works set salary=salary* pany_name=‘First Bank Corporation’
b.
update works a set salary=salary* pany_name=‘First Bank Corporation’ and exists(select 1 from manages b where =)
c.
delete works pany_name=‘Small Bank Corporation’
3-11
select A from R
select * from R where B=17
select * from R,S
select A,F from R,S where C=D
3-12
select * from r1
union
select * from r2
select * from r1
intersect
select * from r2
select * from r1
minus
select * from r2
3-14
create view man_emp_avg_salary(manager_name,avg_salary) as
select ,avg() from works a,man