Re: newton binomial coefficient
From: programmer <programmer_at_brooknet.co.uk>
Date: Wed, 2 Apr 2003 11:39:19 +0100
Message-ID: <b6ef1k$hm2$1_at_pheidippides.axion.bt.co.uk>
Date: Wed, 2 Apr 2003 11:39:19 +0100
Message-ID: <b6ef1k$hm2$1_at_pheidippides.axion.bt.co.uk>
select t1.field, t2.field
from table t1, table t2
where t1.field < t2.field
"Kamal" <kamal80_at_virgilio.it> wrote in message
news:4e766a02.0304010849.5af9a38d_at_posting.google.com...
> Hi everybody.
>
> I have a table with one column with a string datatype.
> I have four records in this table.
>
> car
> home
> dog
> woman
>
> I want to obtain this from a query on this table:
>
> car home
> car dog
> car woman
> home dog
> home woman
> dog woman
>
> How would you do it in pure SQL?
> (Or if you can't, in Oracle, but always with a single query)
>
> Thank you.
>
> Kamal
Received on Wed Apr 02 2003 - 12:39:19 CEST