Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: help needed with a SQL query

Re: help needed with a SQL query

From: Keith Boulton <kboulton_at_ntlworld.com>
Date: Thu, 24 Jan 2002 21:13:05 -0000
Message-ID: <jJ_38.17858$Ph2.2915912@news2-win.server.ntlworld.com>


Your question implies a bad database design, but assuming each column value can be present only once you coud use

select title, min(video) video, min(dvd) dvd, min(vod) vod from <table> group by title

Sunil Pant <spant_at_eline.com> wrote in message news:vk_38.221$497.8376_at_sea-read.news.verio.net...
> Sorry for the mistake in earlier posting.
> I've a query that returns the following result set:
>
> title video dvd vod
> monster NULL 50493 NULL
> 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 - 15:13:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US