Hi--
I saw in the manual that there's some strangeness in how ORDER BY
works. What I'm seeing doesn't seem to match either the manual nor the
posted comments. I'm using 3.23.
I'm doing an "ORDER BY col_1 DESC,col_2". What I want is for the
output to be sorted on col_1 de
an do that (like with an explicit LEFT JOIN or some such), or do
I have to do two separate queries?
Brian
Brian Tiemann wrote:
>
> Hi--
>
> I'm running an art archive, and for the artist listing pages I have to
> come up with a query something like the fo
r and
more complex. Is there any way to get COUNT() to count only the rows
within a grouping? Or am I going about this all the wrong way?
Many thanks in advance for any insight!
Brian Tiemann
-
Before posting, please check: