[UPHPU] select 10 by date, order by name

thebigdog bigdog at venticon.com
Tue Feb 26 13:16:38 MST 2008


Wade Preston Shearer wrote:
>> That doesn't do what you want though. That returns the first 10 rows 
>> sorted by date, and if two have the same date, sorts those by name.
> 
> Looks like this is what I needed:
> 
> SELECT * FROM (SELECT * FROM table ORDER BY day DESC LIMIT 10) ORDER BY 
> name

Make sure your indexes and tables are designed efficiently. Like scott stated, 
this will be a performance bottle neck if not. This would be a great place for 
some stored proc action or a view.

--
thebigdog



More information about the UPHPU mailing list