Re: newton binomial coefficient

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

Sorry, I didn't explain very well.

Here's what I obtained from your query:

NAME                           NAME
------------------------------ --------
car                            home
car                            car
home                           car

I would like to group by these two columns, but without any order.

For example, I don't want "car - home" and "home - car", but just one couple "car - home" or "home - car", without repetition.

And then, why do you filter the query this way (where t1.id < t2.id)? What if I haven't this integer column?

BTW, thank you for the answer.

Kamal Received on Wed Apr 02 2003 - 11:46:01 CEST