有如下表:
pid pname
------------------------------
75 p1
76 p2
vid version pid
------------------------------
118 v1.0 75
119 v2.0 75
121 v3.0 75
133 v1.5 76
pid和vid都自动增长列请问如何选出最新的version?
pid pname
------------------------------
75 p1
76 p2
vid version pid
------------------------------
118 v1.0 75
119 v2.0 75
121 v3.0 75
133 v1.5 76
pid和vid都自动增长列请问如何选出最新的version?
select a.pid,a.pname,b.version
from table_1 a,(
select pid,version
from(select vid,version,pid,row_number()over(partition by pid order by vid desc) rn from table_2 )
where rn=1) b
where a.pid=b.pid;