SELECT count( 1 ) AS rank, r.trainee_id AS traineeId FROM training_trainee_course_relate r
WHERE
r.deleted = 'normal'
AND r.STATUS = 'learned'
AND r.merchant_id = 1
AND date_format( r.updated, '%Y-%m-%d' ) >= '2020-10-10'
AND date_format( r.updated, '%Y-%m-%d' ) <= '2021-10-10'
GROUP BY
r.trainee_id
ORDER BY
rank DESC
报错:
> 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'rank, r.trainee_id AS traineeId FROM training_trainee_course_relate r
WHERE
r.' at line 1
LIMIT 10