[UPHPU] select 10 by date, order by name

Wade Preston Shearer lists at wadeshearer.com
Tue Feb 26 13:14:17 MST 2008


> Looks like this is what I needed:
>
> SELECT * FROM (SELECT * FROM table ORDER BY day DESC LIMIT 10) ORDER  
> BY name

I spoke too soon… that wasn't entirely complete. For those interested,  
the above query also needs the sub query assigned to an alias
-------------- 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/841cddbb/smime.bin


More information about the UPHPU mailing list