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
- 25778 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
Can a filed occur in several field groups? : abap modularization
how to create module pool program using table controls based on selection criteria specified for sales document item in the first screen and item details in the second screen. plz mention the detail coding Tahnks, Rahul
What are the basic objects of the data dictionary? : abap data dictionary
What is luw or data base transaction ?
Can we make use of flow logic control key words in abap/4 and vice-versa?
Explain different types of locks?
Explain the Importance of pa20? : abap hr
When was the sap abap being created?
What is the abap program name to process the batch input session automatically? : abap bdc
Does SAP has a GUI screen painter or not? If yes what operating systems is it available on? What is the other type of screen painter called?
What is difference between dialog program and a report?
Did you create primary index?
What is asynchronous and synchronous update?
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain.? : abap data dictionary
What is an on”*-input filed” statement?
