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博客 ” ，链接：https://blog.itpub.net/22936840/viewspace-750125/ ，如需转载，请注明出处，否则将追究法律责任。
