根据id获取版本号最大的

SELECT * FROM ( 
SELECT * ,row_number () over (PARTITION BY `mdis_id` ORDER BY mdis_version DESC 
) AS v_rank from mdis_info) 

as a where a.v_rank=1 
AND DeletionStateCode=0 AND mdis_fb_status IN ('10','30','40');