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%'
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%'