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 are the events used for logical database?
How can you manipulate the presentation and attributes of interactive lists?
How many default tab strips are there? How to insert more tabs in it?
What are field groups?
What is alv programming in abap?
What are the steps in creating screen ?
How do you work with semi colon se[arated files in BDC ?
What is alv programming in abap? When is this grid used in abap? : abap hr
Define database layer? : abap data dictionary
What are the screen painter and menu painter?
Do we have to migrate all sapscript forms to smart forms?
What is a logical database?
Mention what is alv programming in abap?
what is difference between user exit, customer exit and badi?
Explain what are the different functions used in sap script?