SELECT t.*,
(SELECTcount(distinct s.quiz_attempt_id) FROM quiz_log s
WHERE s.app_user_id = t.app_user_id
AND s.timestamp <= t.timestamp) as Your_Cnt
FROM quiz_log t
WHERE ....
- sagi
1
选择 t.,(SELECT count() FROM quiz_log s WHERE s.app_user_id = t.app_user_id AND s.timestamp <= t.timestamp) as Your_Cnt FROM quiz_log t GROUP BY quiz_attempt_id。我刚试了一下,但它显示 Your_cnt 列分别为 1、11 和 21? - Pete Naylor