关于获取数据库表中相同类型的数据最大的一条记录

select * from public.manufacture_schedule as a
where version = (select max(b.version)
from public.manufacture_schedule as b
where a.no = b.no ) order by no