mysql GROUP BY 后 having 无数据

Question

    select id,sort,voucher_id from rcm_voucher_detail where   voucher_id='2b87e67c6cb449d48760b907224ad569'

    select id,sort,voucher_id from rcm_voucher_detail where   voucher_id='2b87e67c6cb449d48760b907224ad569' GROUP BY voucher_id HAVING    sort = min(sort)

select id,sort,voucher_id from rcm_voucher_detail where   voucher_id='2b87e67c6cb449d48760b907224ad569' GROUP BY voucher_id HAVING    sort = max(sort)

Answer 1

having 后面跟聚合函数 ，不能放列 。 意思事 min（sort)>2 可以。 但 min(sort)>sort 不可以。