StringPath maxVisit = Expressions.stringPath("max_pat_visit");
StringExpression maxVisitExpression = Expressions.stringTemplate("substring_index( group_concat( {0} order by {1} desc,{2} desc ), ',', 1 )",
qPatVisit.id, qPatVisit.entrydept, qPatVisit.createtime);
SQLQuery maxVisitGroupPat = sqlQueryFactory.selectDistinct(maxVisitExpression.as("mid"))
.from(getPatVisit().as("patVisit"));
mysql 5.7 分组查询排序获取组内第一条数据
最新推荐文章于 2024-05-09 22:38:32 发布