Re: newton binomial coefficient
Date: Tue, 1 Apr 2003 10:19:44 -0800
create table things (
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
> Hi everybody.
> I have a table with one column with a string datatype.
> I have four records in this table.
> 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.
Received on Tue Apr 01 2003 - 20:19:44 CEST