1、'Operand should contain 1 column(s)'
select avg(salary) as avg_salary
from salaries
where salary not in(select max(salary),min(salary)
from salaries
where to_date='9999-01-01')
and to_date='9999-01-01'
错误:子查询中有两列,in条件后面有多个字段
2、 "Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'c.name' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by"
分组之后SELECT子句中出现其他字段