Select num,id, date
FROM
(
Select *, ROW_NUMBER() OVER(partition by num,id Order by date desc) as rnk
FROM source_table
)a
WHERE rnk = 1;

SELECT NUM,ID,DATE FROM TABLE_TEMP
QUALIFY RANK OVER(PARTITION BY NUM,ID ORDER BY DATE DESC)=1;

您可以使用单行查询来完成此操作
从表\u temp qualify rank over（partition by num，id order by date desc）=1中选择num，id，date；

通过使用相关子查询

select * from your_table t 
   where t.date= (
                 select max(date) from your_table t1 
                 where t1.num=t.num and t1.id=t.id
                 )

你可以用 max() 功能

select num,id,max(date) from your_table t
group by num,id