Re: Need SQL guru's help: Best query?

The GROUP BY clause will NOT order your results. It simply "groups" like information into a single row summary result. Thus the name.
==========Chris Fischer, 3/25/96==========

cdye_at_dnt.dialog.com (Charles Dye (PC)) wrote:

>SELECT model_number, min(model_number)
>FROM model_table
>group by model_number
>order by model_number
>/

In this case, the ORDER BY clause is redundant and unnecessary as to do the GROUP BY oracle will already sort the rows. Adding the order by simply causes oracle to sort the rows again.

+------------------------------------------------------------+
| Chris Fischer                           cfischer_at_nando.net |
| Sr. Systems Analyst                    Work: (919)676-0062 |
| Toys "R" Us                                                |
+------------------------------------------------------------+