SQL: SUM\AVG FUNCTION CAN NOT WORK WITH LIKE #36039
Description
In 6.5, SQL: SUM\AVG FUNCTION CAN NOT WORK WITH LIKE
the sql which like below is not work.
eg；
select avg(salary), sum(salary) from emp where first_name like 'G%'
{{ message }}
In 6.5, SQL: SUM\AVG FUNCTION CAN NOT WORK WITH LIKE
the sql which like below is not work.
eg；
select avg(salary), sum(salary) from emp where first_name like 'G%'