1-9.sql

来自「这是一个数据库课程设计的sql语言」· SQL 代码 · 共 8 行

select distinct cno
from   sending,nmtable
       where sending.nmno=nmtable.nmno and nmtable.title='人民日报'
       group by cno
       having count(distinct issue)=(select count(distinct issue)
                                   from sending,nmtable
                                   where sending.nmno=nmtable.nmno and nmtable.title='人民日报')