Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between select single * and Select
upto 1 row?
- 6 Answers
- 22172 Views
- Yash Technologies, I also Faced
- E-Mail Answers
Answer Posted / ad
The SELECT SINGLE statement selects the first record in the
database table depending on the condition mentioned in the
WHERE clause. Only the first record is returned and may not
be unique. ENDSELECT keyword is not needed here.
But for the case of SELECT UPTO 1 ROW, all relevant records
are being selected depending on the WHERE clause. Then any
aggregate or grouping or ordering condition is applied to
them and only the 1st record from the resultant set is
being returned. ENDSELECT is must here.
SELECT SINGLE should be used for selecting with full
primary key combination but SELECT UP TO 1 ROWS is the
special case of SELECT UP TO n ROWS and can be used with
any WHERE condition.
As regarding the speed or performance it depends on various
conditions. If your database table contains several
entries, then SELECT UPTO 1 ROWS might take a longer time
to fetch and order all relevant records. But for limited
entries check for full primary key combination takes more
time in case of SELECT SINGLE. If you donot provide all
primary keys in SELECT SINGLE you will get message during
extended syntax check (SLIN).
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How do you take care of performance issues in your ABAP programs?
Explain the client concept of sap.
Structures can contain data only during the runtime of a program (t/f) : abap data dictionary
What do is landscape in sap project, I think its related to no. Of servers used, pls correct me if I am wrong, or what it is? : sap abap hr
Difference between sy-tabix and sy-index? Can you check sy-subrc after perform?
Why do we use abstract class
What are the difference between call screen and leave screen?
What are number ranges?
What is screen flow logic? What are the sections in it?
Is logo in script 1st stored as tiff format before uploading or in jpeg format?and where is that stored after uploading?
How do you find if a logical database exists for your program requirements?
where do we store all custom programs in SD module?
ABAP : Classical reports events name
How many main windows will be there in a page window?
how to read the standard field value in your custom program.
