[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  
BY name

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2425 bytes
Desc: not available
Url : http://uphpu.org/pipermail/uphpu/attachments/20080226/70c7c390/smime.bin


More information about the UPHPU mailing list