Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help needed with a SQL query
Thanks Eric.
SP
"Eric Fortin" <emfortin_at_earthlink.net> wrote in message
news:%u_38.10678$ag5.927595_at_newsread2.prod.itd.earthlink.net...
> 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 - 17:16:47 CST