what is the difference between [select single xxx from ...]
and [select * from ... up to one row]?
- 4 Answers
- 6332 Views
- I also Faced
- E-Mail Answers
Answer Posted / harsha
upto one row is faster than select * from
select single xxx from xxx into wa xx = xxx-xx means it will check all the fields and finally gives a first possible record in the selected group of record
select * from xxx in wa where xx-xxx upto one row means it retrieves only first possible record of table satisfying th condition.
please revert me if any issues with this answer. i dunno weather its ryt r rong.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
Explain what are the problems in processing batch input sessions? How is batch input process different from processing on line?
What function does data dictionary perform?
1)can any body tell the transport request number concept and 2)there are 3 screens in one screen u have uploaded the resume and second screen also u have done the same thing but when u are uploading the resume in third screen u got some error in somewhere else but whatever u have uploaded the resume in 1 and 2 should not
What is new enhancement framework?
What are the attributes of the data in data dictionary? : abap data dictionary
How to upload data using catt ? : abap hr
How do u set up background jobs in SAP? What r the steps? What are the event driven batch jobs?
Differentiate screen painter from menu painter.
How to create a button in selection screen ?
what is the transaction transaction for setting parameters rdisp/buffermode
Which infotype records can not be deleted ? : abap hr
I need some information regarding Vcentric Test pattern ? with questions.
Explain what is sap script? What is the purpose of sap script?
what is the purpose of BAPI BAPI_CUSTMATINFO_GETLIST What is input and output of this BAPI.
What is the difference between sy-tabix and sy-index? Where it is used?
