|
Posted by Johnny on 09/13/06 17:47
"j0sh" <josh@pixael.com> wrote in message
news:45082388$0$35069$4fafbaef@reader4.news.tin.it...
> hi all
>
> why if i make a select with "group by" and "order by id desc" mysql
> select ever the first id and not the last?
>
> example
>
> select *.a,*.b from a,b where a.id=b.id group by a.id desc
desc doesn't apply to 'group by' AFAIK(not much...)
http://www.techonthenet.com/sql/group_by.php
desc usually used with 'order by'
Navigation:
[Reply to this message]
|