论坛 › Oracle运维 › ORACLE部分经典笔记

yzwj2004 发表于 2018-9-25 09:42:36

ORACLE部分经典笔记

:　　1.select lessname from lesson where lessid in
　　(select lessonid from score where studentid in(select studentid from score group by studentid
　　having avg(score)=(select (min(avg(score))) from score group by studentid)));
　　2. select lessname from lesson where lessid in
　　(select lessonid from score where studentid in(select studentid from score group by studentid
　　having avg(score)=(select (min(avg(score))) from score group by studentid)));

查看完整版本: ORACLE部分经典笔记