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
- 7749 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 For-period and In-period
Have you processed BDCs ?
What is the relationship existing between the various data elements? : abap data dictionary
What is open sql vs native sql ?
How to display if the value entered contains records or not?
What are the different software packets available in the market? : sap abap hr
WHAT ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA
Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary
What is the difference between Classic badi and Kernal badi ?
What are the basic objects of the data dictionary? : abap data dictionary
What are the user interfaces of interactive lists?
Will 50,000 records be uploaded directly into APP's Server?
How will you define org structure in MM?
10) How to get Item Header in Sales Order?
If I forgot some command in sap script e.g.: Suppress zero display – how to do find it?
