count, max, dense_rank

select  orderid,
            canclestate,
            reportstatus
from
(select orderid,
            canclestate,
            reportstatus,
            regdate,
            max(regdate) over(partition by orderid) max_regdate
  from misnew.mis_check_data_back)
where regdate = max_regdate;

select orderid, canclestate, reportstatus
from(
select orderid, canclestate, reportstatus,
dense_rank() over(partition by orderid order by regdate desc) rn
from misnew.mis_check_data_back
) where rn=1;

  min(C_Order.rowid) keep(dense_rank first order by rownum)

 

select b.col01,b.col02 from (
select a.col01,a.col02,count(1) over (partition by col01 ) ac
from a  ) b where b.ac=1 and b.col02=1;

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/22936840/viewspace-750125/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/22936840/viewspace-750125/