select * from t_pmsdata_statistic_hour d where 1=1 and d.plantSeq = #{plantSeq} and d.inputDate = #{inputDate} order by inputHour desc select * from t_pmsdata_statistic_day d where 1=1 and d.plantSeq = #{plantSeq} and d.inputYear = #{inputYear} and d.inputMonth = #{inputMonth} and d.inputDay = #{inputDay} order by inputYear asc, inputMonth asc, inputDay asc