Online Tutorials & Training Materials | STechies.com
Register Login

Difference between Select single * and Select upto 1 row

|| || 1

Difference between Select single * and Select upto 1 row
Stechies

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
    ‘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 -

Related Articles

0.0128 seconds.