SELECT * FROM Table A WHERE i_CreateDate=(SELECT MAX(i_CreateDate) FROM Tableb AS b WHERE A.ManId=b.ManId)
表:TableA :TableB=1:N
ManId 分组字段
SELECT * FROM Table A WHERE i_CreateDate=(SELECT MAX(i_CreateDate) FROM Tableb AS b WHERE A.ManId=b.ManId)
表:TableA :TableB=1:N
ManId 分组字段