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

Home -> Community -> Usenet -> comp.databases.theory -> Re: Is it possible to merge the column in SQL Queries.

Re: Is it possible to merge the column in SQL Queries.

From: Aakash Bordia <a_bordia_at_hotmail.com>
Date: Thu, 21 Dec 2000 15:32:44 -0800
Message-ID: <3A42931B.43E3CF58@hotmail.com>

I think UNION wont work to his question. His question is of pivoting 2 columns into one and there is no easy SQL solution to it AFAIK. -Aakash

Arto Viitanen wrote:

> >>>>> "jainbi" == jainbi <jainbi_at_my-deja.com> writes:
> jainbi> Yes,I am new in databases and trying to pick out some thing, will be
> jainbi> great if u send some more links, problem is: If I have the table of
> jainbi> two column ( (10,20,30,40) ,(1,2,3,4) ), how can i view it as a
> jainbi> single column (1,2,3,4,10,20,30,40),
>
> How about:
>
> select first
> from table
>
> union
>
> select second
> from table
>
> ?
>
> --
> Arto V. Viitanen av_at_cs.uta.fi
> University of Tampere, Department of Computer and Information Sciences
> Tampere, Finland http://www.cs.uta.fi/~av/
  Received on Thu Dec 21 2000 - 17:32:44 CST

Original text of this message

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