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: newton binomial coefficient

Re: newton binomial coefficient

From: Mikito Harakiri <mikharakiri_at_ywho.com>
Date: Tue, 1 Apr 2003 10:19:44 -0800
Message-ID: <ZQkia.8$Pt1.179@news.oracle.com>


create table things (

   id integer,
   name varchar2(30)
)

insert into things values (1, 'car');
insert into things values (2, 'home');
insert into things values (3, 'car');

select t1.name, t2.name
from things t1, things t2
where t1.id < t2.id

"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 Tue Apr 01 2003 - 12:19:44 CST

Original text of this message

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