SELECT R1.* FROM ( ) R1 LIMIT #{pgtl.startNo}, #{pgtl.listPerPage} SELECT R1.* FROM ( select * from t_price where inputYmd <= #{inputYmd} order by seq desc, typeCode desc ) R1 LIMIT 0, 2 select inputYmd, typeCode, tradeYmd, min, max, avg from t_price where inputYmd like concat(#{inputMonth}, '%') group by inputYmd, typeCode select inputYmd, typeCode, tradeYmd, min, max, avg from t_price where inputYmd between DATE_ADD(#{inputYmd}, INTERVAL -8 DAY) and #{inputYmd} group by inputYmd, typeCode