Oracle根据行号达到分组排序取第一条的效果,排序后取第一条

Oracle数据无法根据单个字段进行分组，而mysql可以，如果想要达到根据单个字段进行分组可以查询他的行号获取rowNumber达到单个字段分组取第一条效果

SELECT *        
   FROM (
	 SELECT ROW_NUMBER() OVER(PARTITION BY EMPLOYEE_NUMBER  ORDER BY 	RECEIVE_DATE DESC) rn,        
         XXCT_LABOR_CONTRACT_RECEIVE.*        
         FROM XXCT_LABOR_CONTRACT_RECEIVE
				 WHERE EMPLOYEE_NUMBER in ('43149','43148')
				 )        
  WHERE rn = 1   ;

Oracle排序后取第一条数据

SELECT * from 
(SELECT * FROM "XXCT_PROCESS_APPROVAL" a WHERE a.WORK_ITEM_ID ='a7e562f4-6308-47ec-b303-0c53b042ab6b'ORDER BY a."date_now" DESC)
WHERE ROWNUM =1