摘要: 如图所示 阅读全文
posted @ 2020-02-03 03:12 renguanyu 阅读(135) 评论(0) 推荐(0)
摘要: 一、样例SQL SELECT ENAME,MAX(SAL) AS MAX_SAL FROM EMP WHERE ENAME IS NOT NULL GROUP BY ENAME HAVING MAX(SAL) > 1000 ORDER BY MAX_SAL 二、执行顺序 1、FROM 2、WHERE 阅读全文
posted @ 2020-02-03 02:35 renguanyu 阅读(389) 评论(0) 推荐(0)