[UPHPU] select 10 by date, order by name

Wade Preston Shearer lists at wadeshearer.com
Tue Feb 26 12:49:28 MST 2008


> select * from table t order by t.date desc, t.name desc limit 10

Wow. I didn't know you could order by multiple columns. Thank you.

-------------- 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/085968cb/smime.bin


More information about the UPHPU mailing list