假如有下面查询语句,现在是返回多行。如何写resultMap 呢,谢谢
select distinct G.gameId,G.name,G.createtime,G.maincategoryid,G.subcategoryid,G.fee,P.filterfield1
from WCgame G, GameInfo P
where G.gameId = P.gameId
order by G.createtime desc
limit 1,6;
假如有下面查询语句,现在是返回多行。如何写resultMap 呢,谢谢
select distinct G.gameId,G.name,G.createtime,G.maincategoryid,G.subcategoryid,G.fee,P.filterfield1
from WCgame G, GameInfo P
where G.gameId = P.gameId
order by G.createtime desc
limit 1,6;