Last answered:

21 Feb 2023

Posted on:

19 Feb 2023

0

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)
Posted on:

21 Feb 2023

0

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