SQL

2026/1/23 2:59:11

where 3 <= ALL ( select count(*) from Depends D where D.eno=E.eno) (答案2)

select E.ename, E.ename from Employees E,

(select eno, count(*) as d_num from Depends group by eno) D where E.eno = D.eno and D.d_num >= 3

(答案3)

Select E.eno, E.ename

from Employees E, Depends D1, Depends D2, Depends D3 Where E.eno = D1. eno and E. eno = D2. eno and E.eno=D3.eno

and D1.name<>D2.name and D1.name<>D3.name and D2.name<>D3.name

(答案4)

select E.eno, E.ename

from Employees E, Depends D where E.eno = D. eno group by E.eno, E.ename having count(*) >= 3


SQL.doc 将本文的Word文档下载到电脑
搜索更多关于: SQL 的文档
相关推荐
相关阅读
× 游客快捷下载通道(下载后可以自由复制和排版)

下载本文档需要支付 10

支付方式:

开通VIP包月会员 特价:29元/月

注:下载文档有可能“只有目录或者内容不全”等情况,请下载之前注意辨别,如果您已付费且无法下载或内容有问题,请联系我们协助你处理。
微信:xuecool-com QQ:370150219