topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Sun, 16 Oct 2005 07:53:08 GMT

Hi,

what is the difference between select single * and

select * upto one row

regards,

vijay.

Re: select statement

Former Member — Sun, 16 Oct 2005 08:06:52 GMT

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

Re: select statement

Former Member — Sun, 16 Oct 2005 08:07:43 GMT

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

Re: select statement

Former Member — Mon, 17 Oct 2005 01:40:40 GMT

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