group by +left join+count(1)查询实例
今天要做一个新的功能开发,把项目下载下载看了看,在dao层看见下面一段数据库查询语句:public Map queryConsultTotalList(ConsultParamVo vo, PageRequest pageRequest) { String proCountSql = "select doctorid, isproblem, count(1) rn from jkmh_w