2023_10_10_MYSQL_DAY_02_笔记

2023_10_10_MYSQL_DAY_02_笔记 #在 FROM 子句中使用子查询 SELECT a.ename, a.sal, a.deptno, b.salavg FROM emp a, (SELECT deptno, AVG(sal) salavg FROM emp GROUP BY de
posted @ 2023-10-10 23:42  Kbaor  阅读(29)  评论(0)  编辑  收藏  举报