I think I'm right in assuming that the sequence for a GROUP BY clause is the same as for the equivalent ORDER BY clause but I want to make sure.

Roy Lambert

Roy,

<< I think I'm right in assuming that the sequence for a GROUP BY clause is
the same as for the equivalent ORDER BY clause but I want to make sure. >>

The order of the expressions in either clause is completely up to you, so
I'm not sure what you're asking.  Could you elaborate on what you mean by
"sequence" in your case ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim

><< I think I'm right in assuming that the sequence for a GROUP BY clause is
>the same as for the equivalent ORDER BY clause but I want to make sure. >>
>
>The order of the expressions in either clause is completely up to you, so
>I'm not sure what you're asking. Could you elaborate on what you mean by
>"sequence" in your case ?

Just grabbing a convenient example does having

GROUP BY _PNO,COALESCE(_Result,'-'),COALESCE(_Analysis,'-')

require order the query essentially in the same sequence as

ORDER BY _PNO,COALESCE(_Result,'-'),COALESCE(_Analysis,'-')

Reading between the lines of your reply I can use a different ORDER BY clause to re-sequence the data produced by the GROUP BY clause. The amount I have still to learn never fails to astound me.

Roy Lambert

Roy,

<< Just grabbing a convenient example does having

GROUP BY _PNO,COALESCE(_Result,'-'),COALESCE(_Analysis,'-')

require order the query essentially in the same sequence as

ORDER BY _PNO,COALESCE(_Result,'-'),COALESCE(_Analysis,'-') >>

Okay, that's what I thought you meant, but I wanted to be sure.  Yes, you
can have a completely different ORDER BY sequence from the GROUP BY
sequence.

--
Tim Young
Elevate Software
www.elevatesoft.com