Does order by City,name help?

----- Original Message ----- 
From: "Robert Pruitt" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Thursday, February 10, 2005 10:11 AM
Subject: Compound Order By


> I'd like to do a dual order by. First, I want to order by City, then I 
> want to order name. That way, the names within the city are alphabetized.
> 
> I can easily do an order by City into a temp table, then order by name 
> from within the temp table. Is this the best way? Is this the only way?
> 
> Just wonderin'
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]
> 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to