Hi David,
I'm currently in Frankfurt/Main (around 150 km north from Karlsruhe), but
this evening I'll visit my parents who live around 50 km south from
Karlsruhe and in this way I'll pass Karlsruhe.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von David FOXWELL
Gesendet: Thursday, August 07, 2008 10:35
An: Midrange Systems Technical Discussion
Betreff: RE: SQL : subtotals and total
Thanks Brigitta, although I didn't need any sorting.
I visited Karlsruhe yesterday evening. Anywhere near you?
-----Message d'origine-----
De : midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] De la part de BirgittaHauser Envoyé
: jeudi 7 août 2008 10:07 À : 'Midrange Systems Technical Discussion' Objet
: AW: SQL : subtotals and total
Hi,
Without an explicit request to ORDER BY, there is nothing for sure to
be /followed by/ anything, regardless of how many times the given
SELECT may *appear* to effect some perceived ordering.
What you say?
If you need a predefined sequence in your result set, you need to add an
order by clause. Even if you specify a logical file with right key
fields(which is not a good design because the queries must be executed by
the CQE), the optimizer may use a different access path with an other
sequence and consequently the result is not sorted in the expected way.
The optimizer searches for a way to get the requested data as fast as
possible and if necessary sortes the data after selection.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok) "What is
worse than training your staff and losing them? Not training them and
keeping them!"
-----Ursprüngliche Nachricht-----
Von: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] Im Auftrag von David FOXWELL
Gesendet: Thursday, August 07, 2008 09:39
An: Midrange Systems Technical Discussion
Betreff: RE: SQL : subtotals and total
Chuck wrote:
Without an explicit request to ORDER BY, there is nothing for sure to
be /followed by/ anything, regardless of how many times the given
SELECT may *appear* to effect some perceived ordering.
What you say?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
As an Amazon Associate we earn from qualifying purchases.