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

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                                                |
+------------------------------------------------------------+