【2022.4.6】数据库系统概念第六版第三章

本文主要是介绍【2022.4.6】数据库系统概念第六版第三章，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

---

一、题目

二、3.11

a.

select distinct name
from takes,student,course
where takes.ID=student.ID and takes.course_id=course.course_id and course.dept_name='Comp. Sci.'

b.

select distinct(student.ID),name
from takes,student
where not exists
(select *
from takes,student
where takes.ID=student.ID and  takes.year<2009)

---

c.

select dept_name,max(salary)
from instructor
group by dept_name

d.

with tmp as (select dept_name,max(salary) as s
from instructor
group by dept_name)
select min(s) as minus
from tmp

总结

作业又不收了 老师我爱你

这篇关于【2022.4.6】数据库系统概念第六版第三章的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---