select statement

[Former Member]

Hi,

what is the difference between select single * and

select * upto one row

regards,

vijay.

[Former Member]

Hi,,

here is a link that explain it:

http://www.sap-img.com/abap/difference-between-select-single-and-select-upto-one-rows.htm

Best regards,

Stefan

[Former Member]

Hi Vijay ,

No difference functionally except that Select single * will give a warning in extended syntax check if you dont specify the full key of the table in where clause . Select * up to 1 rows will not give a warning in syntax check . If you have full key then use select single else use up to 1 rows .

Cheers

Message was edited by: Sanjay Sinha

[Former Member]

if you want to do a master check, single is better than UP TO 1 ROWS, the reason is the single only try to get the entry meet the condition, and return it back. But UP TO 1 ROWS try to select out all of the entries meet the condition, and after that, it return the first entry to our application.

So the performance difference is very obviously.

single select can't assure which entry will be return when multiple meet the condition. normally it will return the first entry it find out.

But in the master check case, it is enough.

thanks