please clear this what is the diff b/w select single * and
select up to 1 row?
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
What is erp? : sap abap hr
In the `select' statement what is group by ?
What is the use of message command in a report? What are the different message types?
Explain buffering
dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?
What is meant by hotspots?
Did you create primary index?
What is the length of function code at user-command?
Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button
How to write a bdc – how do you go about it?
What are the steps in a bdc session? : abap bdc
Can we include customizing include or an append structure with pooled or cluster tables? : abap data dictionary
What are roles and authorization objects?
what is the difference between Blocked ALV and interactive ALV?
Which infotype records can not be deleted ? : abap hr