[UPHPU] select 10 by date, order by name
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
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.
More information about the UPHPU