Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

Comment on

( #3333=superdoc: print w/ replies, xml ) Need Help??
The order of the grouping should be alphabetical, as this is how SQL databases store their data internally.

However, this is not always true for multi-processor systems, as they can group things simultaneously, so the order is not as important.

hope this helps.

UPDATE:

Sorry guys and galls. The above to statements are untrue (well, I made them up, I guess they’re untrue).

lex opened his first post with the salutation "Dear Monks", and felt the need to post that his question wasn't homework. To my mind, this tells me that he's not a perlmonks newbie, so he knew how this question was going to be received, but he still asked it. He even followed it up with another request for information, without showing he’s done anything to help himself.

My response was supposed to be believable to any one who read it, but didn’t actually _read_ it. I have to admit I enjoyed a moment of guilty pleasure thinking he might copy it down verbatim on his homework sheet.

You might say that's not in the spirit of this site, but neither is the question, or his disregard of the time other people put in to answering it. Anyway, votes count, and I'm minus 6 for this post (my first-ever down voted node) so it shall avoid attempts at comedy in the future.

---
my name's not Keith, and I'm not reasonable.

In reply to Re^3: SQL GROUP BY Clause by reasonablekeith
in thread SQL GROUP BY Clause by lex

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post; it's "PerlMonks-approved HTML":



  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • Outside of code tags, you may need to use entities for some characters:
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.
  • Log In?
    Username:
    Password:

    What's my password?
    Create A New User
    Chatterbox?
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others about the Monastery: (4)
    As of 2014-09-22 02:18 GMT
    Sections?
    Information?
    Find Nodes?
    Leftovers?
      Voting Booth?

      How do you remember the number of days in each month?











      Results (177 votes), past polls