<SQL> SELECT * FROM (
SELECT ROW_NUMBER() OVER(PARTITION BY VTD004 ORDER BY VTD013) as rown, * FROM v_PRCABLEDAILY WHERE VSUMTD008<0 AND VTD004 NOT LIKE '6%') AS T1
WHERE rown = 1 ORDER BY VTD013 </SQL>