equivalent for 'compute' in sql server
hi everyone,
is there any other alt in mysql for the compute in sql server?
it means, for the following query,
CREATE PROCEDURE `pubs_dbo`.`reptq1` ()
select pub_id, title_id, price, pubdate
from `pubs_dbo`.`titles`
where price is NOT NULL
order by pub_id
COMPUTE avg(price) BY pub_id
COMPUTE avg(price)
i had modified it as:
CREATE PROCEDURE `pubs_dbo`.`reptq1` ()
select avg(price),pub_id, title_id, price, pubdate
from `pubs_dbo`.`titles`
where price is NOT NULL
group by pub_id
order by pub_id
but after migration, when i checked the results in sql server and mysql, it does not matched.
is there any other alternative for my problem.
anyone help me?
thanx in advance.
UJVALA