newton binomial coefficient

From: Kamal <>
Date: 1 Apr 2003 08:49:03 -0800
Message-ID: <>

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.

Kamal Received on Tue Apr 01 2003 - 18:49:03 CEST

Original text of this message