Knowledge Management

Question:
Hi All,
What is the difference between select singe * and select * upto
one row
What are the function module types?
What is diffrence between synchronous update and asynchronous update?
Thanks for reply..
Answer:
That's chapter 2 of the basics. Seems to me that you are not going to pass that upcoming interview.
Answer:
Answer:
There's been loads of postings about this and I'm still sticking to my explanation... which is:
Select single: Selects the first record it comes to in the table that matches the selection criteria.
Select Upto 1 rows......:
Performs the selection, then applies any ordering or grouping and builds the result set. It then returns the first row from the result set. Subtly different from above.
R
Have fun!
Answer:
How?
They both would return the same record wouldn't they?
Or would the ordering make them return a different record???
Answer:
Select single .....
from vbap
where vbeln = '123456'
And
Select upto 1 rows
from vbap
where vbeln = '123456'.
Will have the same result.
Select upto 1 rows
from vbap
where vbeln = '123456'
order by posnr descending.
will not it should produce the last item line for the order.
If upto 1 rows was the same as select single then the previous example would return the first record it came to.
Btw - these have have not been checked for syntax.
R
Answer:
Thank you R...Can you clarify my other queries please.
kiru
Answer:
Thank you R...Can you clarify my other queries please.
kiru
These are easily found in the documentation or in this forum.
Regards
R