|
|
|
| Syntactic Confectionery Delight | |
| PerlMonks |
Re(2): ORDER BY COUNT(*)?by dmmiller2k (Chaplain) |
| on Mar 21, 2002 at 04:28 UTC ( #153219=note: print w/replies, xml ) | Need Help?? |
|
Given your GROUP BY clause, your DISTINCT keyword is completely unnecessary. And, by the way, the second column may be equivalently specified as COUNT(*) [AS] col2 or col2=COUNT(*). The ORDER BY clause may alternatively be specified as ORDER BY 2 DESC or as ORDER BY count(*) DESC.
In Section
Seekers of Perl Wisdom
|
|
||||||||||||||||||||||||