Re: Was: maximum number of columns per table

> When you find a piece of paper wide enough to print 1000 columns please
> let me know. ;-)

I agree with you, I never want to print lots of columns.

But the queries do get ugly when you want to do aggragations, unless I'm doing
it wrong. I always end up with things like:

select sum(first_col)
from (

    select a.col_value 'first_col', b.col_value '2nd_col'     from normalized_table a, normalized_table b     where a.id = b.id
    and first_col > X
)
group by 2nd_col

Is there a better way?

Jay Received on Tue Jul 20 2004 - 08:52:47 CDT