摘要: 题目:获取emp表中的最高工资、最低工资 解法: -- 传统的聚合函数 SELECT MAX(T1.salary),MIN(T1.salary) FROM emp AS T1; SELECT salary AS max_salary FROM emp WHERE salary NOT IN ( SE 阅读全文