Re: Cool but ugly SQL

On 6/16/06, vhamberg@xxxxxxxxxxx <vhamberg@xxxxxxxxxxx> wrote:

Cool - Birgitta's post was important. I've a question, though. You say you
did not want Tempfile to be the source of the data. Can you say more - I
mean, as far as I know, it is irrelevant - TempFile is just a name for the
result of the common table expression defined by the "with" - the data
ultimately comes from the original file, too. Anyway, I am just curious
about that statement.

I guess I'm not an SQL newbie anymore, but still a novice.  In my limited
and few & far between, my aging (perhaps incorrect) recollection was that
GROUP BY limits the columns that can be selected to those in the GROUP BY
clause and I wanted to include in my output table all of the fields from the
original file

BTW, that select statement for the max values could probably also have been

written in place in the join, as what is called a nested table expression.
Not always, but usually - YMMV.

Got a code example to get me started?  ;-)

Thanks,
Dan