Error 1055 - No issue when I run the code

Question

When I run this code, I do not get error 1055. How come it works with me?

select emp_no, salary, max(from_date), to_date
from salaries
where to_date >sysdate()
group by emp_no;

Answer 1

Same here

I think the error only happens if you have not disabled 'only full group by' setting

As long as the error does not appear, this setting is disabled and the first query works fine

Submit an answer