Re: Re: Does not MySql support "Order By" in SelectStatement?
| From: | Rasmus Lerdorf | Date: | Mon, 12 Jun 2000 02:42:39 +0000 |
| Subject: | Re: Re: Does not MySql support "Order By" in SelectStatement? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-1586@lists.php.net to get a copy of this message | ||
> But I really can't run an "order by" Select statement.
> The statement is as below:
> mysql> select * from table01 order by age group by age;
> ERROR 1064: You have an error in your SQL syntax near 'group by age' at line 1
> mysql> select * from table01
> -> ORDER BY Age;
>
> And the command line dies after this execute.
> What can I do?
Do it in the right order.
select * from table01 group by age order by age