select caseid,typeid,count(*) as cnt from browrecord
where typeid = '0002'
group by caseid,typeid order by count(*) desc;
^^^^^^^^
where typeid = '0002'
group by caseid,typeid order by count(*) desc;
^^^^^^^^
如果没记录就不排序,有记录了在排
rs=db.executeQuery("select * from browrecord");
if (rs.next()){
db.executeQuery("select caseid,typeid,count(*) as cnt from browrecord
where typeid = '0002'
group by caseid,typeid order by cnt desc");
}
我真搞不懂jdbc连最基本的都会有错,谢谢楼上的兄弟了!
给分!