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
- 7620 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 the disadvantages of logical databases?
How do I find the output type of a table or a program?
What is meant by hot spots? : abap data dictionary
Explain how many types of tables exist and what are they in data dictionary?
What is exception class and test class. How to use it?
Concepts of OO ABAP and why we are using it?
Explain the function module in bdc?
Can you print decimals in type n?
Sal abap on hana interview
In the `select' statement what is group by ?
How do you set up background jobs in sap? What are the steps? What are the events driven batch jobs?
What is the project you are currently working and work that you are doing
If I want to execute a program only in background not in foreground is there any option for this? : abap bdc
In the abap/4 dictionary tables can be defined independent of the underlying database (t/f). : abap data dictionary
What are the objects of the abap dictionary or what types of objects can be created in the abap dictionary? : abap data dictionary
