Re: newton binomial coefficient

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