[UPHPU] select 10 by date, order by name
Wade Preston Shearer
lists at wadeshearer.com
Tue Feb 26 12:59:16 MST 2008
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 2425 bytes
Desc: not available
Url : http://uphpu.org/pipermail/uphpu/attachments/20080226/70c7c390/smime.bin
More information about the UPHPU