sql 查询语句，按表中的某个字段分组去重，每组只查一条最新的数据

模板

select *  
from (select row_number() over(partition by 要分组的字段 order by 分组后每一组用哪个字段排序) rn,  
b.要查询的字段,  
b.要查询的字段  
from 表名称 b  
where 查询的条件) 
where rn = 1  
order by 最后查出的结果集排序字段

例：

select *  
from (select row_number() over(partition by b.NODE_CODE order by b.CREATE_TIME desc) rn,  
b.NODECODE,  
b.create_time  
from MOON b  
where b.create_time > (select  sysdate - interval '2' hour  from dual)) 
where rn = 1  
order by CREATE_TIME desc