赞
踩
select M.* from (
select
SND_L,
SDN_P,
RCV_L,
RCV_P,
FILE_IDX,
FILE_NAME,
DT,
ROW_NUMBER() OVER (PARTITION BY SND_L,RCV_L ORDER BY DT) AS PART_INNER_IDX
FROM
NFTSDB.TSK_TEST
) M
WHERE M.PART_INNER_IDX <= 2
)
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。