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)
having 后面跟聚合函数 ,不能放列 。 意思事 min(sort)>2 可以。 但 min(sort)>sort 不可以。
使用group by时,select 后面的字段要么使用聚合函数,要么是group by后的字段,你select id,sort这个sql不会报错吗?