Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between [select single xxx from ...]
and [select * from ... up to one row]?
- 4 Answers
- 7818 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 a fall back class?
What is view? Different types of view.
What are the types of views? : sap abap data dictionary
How to convert the Unit for 'Distance' (The value from one Unit to another).
What are Tickets in Realtime ?
What are the basic functions of database utility?
What is the differences between abap and ooabap. In which situation we useooabap?
What are the disadvantages of different types of bdc's?
How do you retrieve the data for repetitive structures ? : abap hr
What are the advantages of abap query tool?
What are the mandatory fields to be filled for BAPI_CUSTOMER_CREATEFROMDATA1
What are the functional areas? User groups?
How to do find it?
What happens if we use leave to list-processing without using suppress-dialog?
What are the disadvantages of abap query tool?
