select * from version where pg_name = "com.example.demo" and verson_code= (select MAX(verson_code) from version)
先用从句
(select MAX(verson_code) from version)
查询出最大的verson_code,将此结果作为条件,继续查询,可得结果。
select * from version where pg_name = "com.example.demo" and verson_code= (select MAX(verson_code) from version)
先用从句
(select MAX(verson_code) from version)
查询出最大的verson_code,将此结果作为条件,继续查询,可得结果。