Register Login
Python Photoshop SAP Java PHP Android C++ Hadoop Oracle Interview Questions Articles Other

Difference between Select single * and Select upto 1 row

Updated May 18, 2018

Select single * vs Select upto 1 row

Select single * can work on the work area not on the internal table. It has no endselect.

Select * upto 1 rows can be implemented in Internal table and work area both. It has endselect.

 

Comments

  • 04 Jan 2012 11:52 am rekha Helpful Answer
    ‘Select single *’ – The result of the selection should be a single entry. If it is not possible to identify a unique entry, the system uses the first line of the selection. For e.g.



    DATA : ITAB TYPE ZREKHA_EMP.



    SELECT SINGLE * FROM ZREKHA_EMP INTO ITAB

    WHERE EMPNO = ‘00101’ AND DEPTNO = ‘0010’.



    WRITE : / ITAB-EMPNO, ITAB-EMPNAME,ITAB-DEPTNO.



    Select upto 1 rows -
Recommended Posts:
×