What is the difference between 'Select single * ' and 'Select upto 1 rows'?

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