Re: equivalent for 'compute' in sql server

[ujvala ujvala]

Roland, ok i understood.
thanx for the suggestion. i had modified the query 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 with rollup;

and it displays group-wise records only.

UJVALA