Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
- 9 Answers
- 26526 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / arjun manglekar
1)SELECT single retrives only one record which ever come
across first in data base query
SELECT ..upto 1 row , all records are fetched into a buffer
which are satisfied from Where condition in Data base
query , and from buffer first record is fetched .
>>same as Answer 2
2) If you know all the primary keys in WHERE condition ,
use SELECT single.
If you dont know all primary kyes in WHERE condition , use
SELECT...UPTO
3)Performance:
SELECT UP TO...is gives better performace than select single
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What work you have done in HR module
Hi every one ! You people are doing a great job here , Im going to attend Tata Technologies interivew on this sunday,Can anyone who has already attended this company interivew or other companies interivews in abap pls share ur experience with me and help me to get into job my id ushareddyabap@gmail.com. Thankyou verymcuh
What is the project you are currently working and work that you are doing
please give the remaining answers.
what comes in Timkein written test I hope some body can tell me at this id plz tell it before 9 pm 19 march
How do you get the number of lines in an internal table? How to use a specific number occurs statement?
1/ How do u apprach if error occur in sending idocs ? 2/ where u assigned process code ?
What is your current client number?
How can we handle table control in bdc? : abap bdc
Did you create secondary index?
