在select列表中无效，因为它不包含在聚合函数或GROUP BY子句中

use qcvalues_test
go

select [finalConc]
      ,[rowid] from qvalues where rowid in (select rowid from batchinfo where instrument = 'TF1') 
and name='qc1'
and compound='etg'
group by finalConc
having COUNT(rowid)=2
use qcvalues_test
go

select [finalConc]