[ABAP] 정렬순 n개의 row선택 How to sort and select DB at the same time

    SELECT * UP TO 1 ROWS 
      FROM ZFIT0210
     WHERE BUKRS    EQ GT_LIST - BUKRS    " 회사코드 
       AND ANLN1    EQ GT_LIST-ANLN1    " 자산
       AND ZCTNUM_B EQ P_CONTRT         " 계약번호
    ORDER BY FLOWNO DESCENDING .
    ENDSELECT.

 

SELECT SINGLE 하고 Order by를 주면 에러가 난다.

You will get error if you SELECT SINGLE and Order by

 

반응형