select t. *, ROW_NUMBER() OVER(PARTITION BY CUST_NO ORDER BY DATE DSEC)RN from table t WHERE RN=1
Oracle取同一类别中某属性最大或者最小值的一条
最新推荐文章于 2023-01-20 10:28:08 发布
select t. *, ROW_NUMBER() OVER(PARTITION BY CUST_NO ORDER BY DATE DSEC)RN from table t WHERE RN=1