ORDER BY ... DESC evaluation

2001-02-02 Thread Brian Tiemann
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

[Fwd: Re: COUNT question]

2001-01-26 Thread Brian Tiemann
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

COUNT question

2001-01-26 Thread Brian Tiemann
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: