WITH TEMP AS(
SELECT ROW_NUMBER() OVER(PARTITION BY FROM_RETAILER_CODE ORDER BY DIS) NUM,FROM_RETAILER_CODE,TO_RETAILER_CODE,DIS,TIME
FROM xxxxxxxx
)
SELECT FROM_RETAILER_CODE,TO_RETAILER_CODE,DIS,TIME FROM TEMP START WITH FROM_RETAILER_CODE=xxxxxxx AND NUM=1
CONNECT BY PRIOR TO_RETAILER_CODE=FROM_RETAILER_CODE AND NUM =1