Re: Is it possible to merge the column in SQL Queries.
From: Philip Lijnzaad <lijnzaad_at_ebi.ac.uk>
Date: 22 Dec 2000 09:13:30 +0000
Message-ID: <u7snngx1hh.fsf_at_sol6.ebi.ac.uk>
Date: 22 Dec 2000 09:13:30 +0000
Message-ID: <u7snngx1hh.fsf_at_sol6.ebi.ac.uk>
On Thu, 21 Dec 2000 15:32:44 -0800,
"Arto" == Aakash Bordia <a_bordia_at_hotmail.com> wrote:
Arto> I think UNION wont work to his question. His question is of pivoting 2 Arto> columns into one
what do you mean by pivoting? To me it looks like UNION is exactly what's needed.
Philip
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
>>
-- C++: The power, elegance and simplicity of a hand grenade. (Kenneth C. Dyke) ----------------------------------------------------------------------------- Philip Lijnzaad, lijnzaad_at_ebi.ac.uk \ European Bioinformatics Institute,rm A2-08 +44 (0)1223 49 4639 / Wellcome Trust Genome Campus, Hinxton +44 (0)1223 49 4468 (fax) \ Cambridgeshire CB10 1SD, GREAT BRITAIN PGP fingerprint: E1 03 BF 80 94 61 B6 FC 50 3D 1F 64 40 75 FB 53Received on Fri Dec 22 2000 - 10:13:30 CET