达梦数据库取最大时间的数据并限制条数

select * from  表 where district_code in ('深圳') and INDEX_CODE in ('IDX276','IDX3017','IDX3023','IDX3021','IDX3019','IDX3018','IDX3022','IDX3024','IDX3020') and stat_date>='201902' and stat_date<=( select max(stat_date) from  BIZ_ECONOMY.BIZ_ECONOMIC_INDEX1 where INDEX_CODE ='IDX3020') order by stat_date desc limit 0,9;
//select max(stat_date) from  BIZ_ECONOMY.BIZ_ECONOMIC_INDEX1 where INDEX_CODE ='IDX3020')取当INDEX_CODE ='IDX3020'的最大时间
//limit 0,9取前面的9条数据