From: <sinisa
Date: March 13 1999 11:35pm
Subject: order by multiple columns
List-Archive: http://lists.mysql.com/mysql/182
Message-Id: <14058.63050.720948.147542@monster.local.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Marc Antony Vose writes:
 > Hey there...
 > 
 > Sorry if this is an elementary question, but can I order a result set by
 > more than one column?
 > 
 > Something like "select blah blah blah order by avg,lastname"
 > 
 > Cheers.
 > 
 > Marc
 > 

Hi!

Of course you can. Something like this:

select blah1, blah2, blah3 .. from table order by blah1,blah2

Sinisa

+---------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___        ==  mysql@stripped        |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|        Sinisa Milivojevic      |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|        mailto:sinisa@stripped |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|        Belgrade                |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|_____   Serbia                  |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                           |
|             /*/             \*\                   Developers Team   |
+---------------------------------------------------------------------+