http://www.perlmonks.org?node_id=495042


in reply to SQL GROUP BY Clause

You are desperately OT in this forum.

Aside from that, let me analyze your question.

Does the order of columns in a SQL Group By clause matter?

Why would anyone ask somathing like that? If you were doing something practical with SQL, you could just throw two queries, changing the order of columns in the GROUP BY, and seeing for yourself if they differ or not (I am not going to give you the answer indirectly :-P).

So youy were not doing anything practical. Then why would you be curious about this? The only plausible answer is because somebody asked you. Hence, it's homework.

One more indication of homework is the "discuss" clause. You don't come to a forum and say "discuss" for something you don't know. You can come here, post something in Meditations, say what youy think about that, and then ask for discussion. But discussing some unknown thing that your teacher asks you to find out is hardly something that can tickle our willingness to help.