please clear this what is the diff b/w select single * and
select up to 1 row?
- 5 Answers
- 6985 Views
- I also Faced
- E-Mail Answers
Answer Posted / prasad
Select single * query will retrieve all the records from
the database table with respect to the condition specified
and finally select one single row among the retrieved.
In case of Select up to 1 row,the query starts retrieving
the database and once it gets the 1 row w.r.t its condition
it stops further retrieval.Performancewise using select
single * is not gud.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can we set page headers to details lists?
A function module can be called from a transaction screen outside an abap/4 program. State true or false. : abap modularization
HI GUYS , FOR SAP INSTITUTION ATOS I BEST OR NOT? IAM PLANNING TO LEARN SAP COURSE IN ATOS... GIVE ME UR SUGGESTION ABOT ATOS?
What is sequence number
How did you test the form you developed? How did you taken print?
why to create a custom BAPI if the BAPI already exists? y to find BAPI again? frankly even i dint undstnd tne question properly. if any one come across this q please do anser me.
What is the differences between abap and ooabap. In which situation we useooabap?
How many structures can be created in a Ztable ?
Explain data dictionary in abap?
What happens when you post goods issue after delivery? How does the inventory get reduced after the delivery?
Can you define a field without a data element? : abap data dictionary
Why we are using Macros instead of Function Modules
How will you define org structure in MM?
When to use logical database?
How to call a subroutine in sapscript?
