what is the difference between [select single xxx from ...]
and [select * from ... up to one row]?
- 4 Answers
- 6955 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
What is the difference between commit-work and rollback-work tasks?
Differentiate between table and template ?
What is meant by write lock? : sap abap data dictionary
What are Tickets in Realtime ?
Explain how do you get output from idoc?
What is the Process to transfer IDOC from Outbound System to Inbound system.
What is an interactive report?
How to handle error in session method? : abap bdc
What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
What are the functional areas? User groups?
Sal abap on hana interview
What is meant by hide area?
Can we use on change of between select and endselect?
Can there be more than 1 main window in sap script?
Which function modules can be used to transfer the data using bdc programming? : abap bdc
