Resolved: Error 1055 - No issue when I run the code
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;
1 answers ( 1 marked as helpful)
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