My Table is
id affiliate_id reset_payment date
28 33 14.1 1404212739
29 33 2 1404212800
30 35 2 1404212900
,我想得到所有的值,其中affiliate_id
= 33,这affiliate_id
33应该是最新的。第二行是我的答案
SELECT *
FROM TABLE_NAME
WHERE affiliate_id = 33
ORDER BY date DESC LIMIT 1