比如有如下记录
tablename HHH
bh mc bz
-------------------
H001 book zz
H001 CD zz
H002 book zz
然后用 "select distinct bh from HHH "查询得到数据集rs,
然后用rs.last();count=rs.getRow();为什莫得到的count=3,而不是2，可是我要得到2，该怎模办？？
------解决方案--------------------
select count(*) distinct bh from HHH
------解决方案--------------------
select distinct(bh) from HHH
------解决方案--------------------
理论上应该只有2条,把你的结果打印出来看下数据
------解决方案--------------------
select min(bh) as bh,min(mc) as mc,min(bz) as bz from HHH group by mc;