SELECT * FROM ( SELECT ID,NAME,DATE,ROW_NUMBER() OVER( PARTITION BY ID ORDER BY DATE DESC) ROW_OVER FROM `DW_FIVE` FIVE)FIVE LEFT JOIN DW_MX MX ON FIVE.ID =MX.ID WHERE ROW_OVER =1 -- 保存问题 |
1min目标场景问卷
立即参与
最佳回答 |
||||
|
1
|
|
|||
