1
2
3
4
5
6
7
8
9
10
11
12
13
| package com.hxzk.mapper;
|
| import com.baomidou.mybatisplus.core.mapper.BaseMapper;
| import com.hxzk.pojo.TbAchor;
| import org.apache.ibatis.annotations.Select;
|
| import java.util.List;
|
| public interface AchorDao extends BaseMapper<TbAchor> {
|
| @Select("SELECT a.* FROM tb_achor AS a,( SELECT anchorid, max( GreateTime ) time FROM tb_achor GROUP BY anchorid ) AS b WHERE a.GreateTime = b.time AND a.anchorid = b.anchorid")
| List<TbAchor>getAnchorInfo_all();
| }
|
|
