select title, sum(nvl(video, 0)) VIDEOS, sum(NVL(dvd, 0)) DVDS, sum(nvl(vod,
0)) VODS from bogus group by title
"Sunil Pant" <spant_at_eline.com> wrote in message
news:oh_38.220$497.7983_at_sea-read.news.verio.net...
> I've a query that returns the following result set:
>
> title video dvd vod
> monster NULL 50493 NULL
> monster monster 48359 NULL NULL
>
> I want to display the above query as follows:
> title video dvd vod
> monster 48359 50493 NULL
>
> monster
>
> Any ideas would be appreciated.
> Thanks,
> SP
>
>
Received on Thu Jan 24 2002 - 14:53:15 CST
