有如下版本号
要求求出最大的版本号
select
id
from
(
select
id,
dense_rank() over(order by first desc ,second desc,third desc) as rn
from
(select
id,
cast(split(id,"\\.")[0] as int) as first,
cast(split(id,"\\.")[1] as int) as second,
cast(split(id,"\\.")[2] as int) as third
from
test_3)t1)t2
where rn=1
如有不对,请指正