最新,这里用到了ROW_NUMBER,就是编号,OVER就是分组,分组是通过一小时聚合,聚合后会有编号每一个组的,从1开始到该组结束,取每组的第一条就是最新的 SELECTreport_timeAStimeInterval, cpu_usageAScpuUsage, mem_usageASmemUsageFROM(SELECTreport_time, cpu_usage, mem_usage, ROW_NUMBER()OVER( PARTITIONBYto...