From: Ed Carp Date: March 13 1999 10:46am Subject: Re: [spam 03.04/10.00 -pobox] order by multiple columns List-Archive: http://lists.mysql.com/mysql/153 Message-Id: <008701be6d3e$c498c9e0$74c9a8c0@traveler.airmail.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit >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" Yes. You got it right, too :)