group by - problem

[Patrick Bierans]

> From:           	Berthold Tenhumberg <b.tenhumberg_(at)_web.de>
> select a,b from test group by a sort by b desc;
sort by?

SELECT [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] 
[SQL_BUFFER_RESULT] [HIGH_PRIORITY] [DISTINCT | DISTINCTROW | ALL] 
select_expression,... [INTO {OUTFILE | DUMPFILE} 'file_name' export_options] [FROM 
table_references [WHERE where_definition] [GROUP BY {unsigned_integer | col_name | formula} [ASC 
| DESC], ...] [HAVING where_definition] [ORDER BY {unsigned_integer | col_name | formula} [ASC | 
DESC] ,...] [LIMIT [offset,] rows] [PROCEDURE procedure_name] [FOR UPDATE | IN SHARE 
MODE]] 

Patrick Bierans / LYNET Kommunikation AG/ pbierans_(at)_lynet.de
---------------------------------------------------------------
Das Internet-Systemhaus fuer Multimedia- und Netzwerkloesungen.
Zentrale Luebeck: Fon +49-451-6131-0, Fax -333
Niederlassung Hamburg:  Fon +49-40-65738-0, Fax -333

---
*** Weitere Infos zur Mailingliste und MySQL unter http://www.4t2.com/mysql