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 check tables?
If your project is support project ? when is your implementation has completed ?
What are the functions of lock objects?
What function does data dictionary perform?
What is buffering in abap?
Differentiate between table and template ?
What are the different function modules used in sapscript?
What is exception class and test class. How to use it?
Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?
What work you have done in HR module
What is bdc? : abap bdc
1.If there is one receiver,then To send 10 materials at a time through BD10 tcode, How many Master Idoc create? 2.If there is one receiver,then To send 1 material at a time through BD10 tcode, how many Master Idoc generated? 3.Can I Send Multiple Messges through BD10 tcode?
What are the disadvantages of using explicit enhancement?
Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul