Re: newton binomial coefficient

From: Kamal <kamal80_at_virgilio.it>
Date: 2 Apr 2003 01:46:01 -0800
Message-ID: <4e766a02.0304020146.32b9831e@posting.google.com>

>
> 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 - 03:46:01 CST