Oracle-利用解析函数计算连续、回流
摘要：
---最大连续交易天数 select t2.customer_no,max(t2.co) from (select t1.customer_no,t1.yp-t1.rn rk,count(1) co from (select ctd.customer_no, ctd.order_time yp, row_number() ... 阅读全文
posted @ 2019-03-02 16:26 道人 阅读(406) 评论(0) 推荐(0) 编辑
