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
- 7988 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
Exception handling and how does it transfer from called method to calling method?
What are the different types of parameters?
How to split one Invoice into Multiple ( Step by Step)?
What is the difference between internal tables and extract datasets? : abap modularization
What is lock object ? : abap data dictionary
What is abap work bench?
In which table the material master data is stored?
What is the use of 'table index'?
What are null values?
Have you set up a back ground job? How to create a background job without a variant ? : abap bdc
the problem is that , while i am undergoing with my practice session, i am creating too many new programs.they are occupying much space in my hard-disk. how to delete un-necessary programs completely from my data- base........... plz help me with this .....
what is difference between set screen and call screen ?
could anyone tell me what r real time questions been asked in interviews?i am in urgent need..thanks in advance
what is leave to TRANSACTION?
Can you define a field without a data element? : abap data dictionary
