FROM emp e
LEFT JOIN emp m
ON e.mgr=m.empno
GROUP BY e.ename,e.empno
HAVING MIN(e.sal)>=3000
ORDER BY MIN(e.sal) DESC
[mysql习题]（https://blog.csdn.net/zhang__rong/article/details/82711933?utm_source=blogxgwz8）
FROM emp e
LEFT JOIN emp m
ON e.mgr=m.empno
GROUP BY e.ename,e.empno
HAVING MIN(e.sal)>=3000
ORDER BY MIN(e.sal) DESC
[mysql习题]（https://blog.csdn.net/zhang__rong/article/details/82711933?utm_source=blogxgwz8）
本文标题：2018-11-16第7章第5题
本文链接：https://www.haomeiwen.com/subject/rvhpfqtx.html
网友评论