Posted by j0sh on 09/14/06 09:51
Johnny wrote:
> desc doesn't apply to 'group by' AFAIK(not much...)
> http://www.techonthenet.com/sql/group_by.php
>
> desc usually used with 'order by'
sure... but i'm using desc with order by...
the right example is
select *.a,*.b from a,b where a.id=b.id group by a.id order by a.date
desc (i make a mistake in my example)
Navigation:
[Reply to this message]
|