Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
Answer Posted / vijayaraghavan
Select Single * will pickup only one matching record from the database into the buffer, and returns the same to the internal table.
Select upto 1 rows will pickup all the records matching the condition into the buffer, but return the top record to the internal table.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What is the differences between structure and table in data dictionary in abap?
What are the tcodes for performance tuning?
What is view? Explain the different types of view?
What is the differences between abap and ooabap. In which situation we useooabap?
What are the different functions used in sap script? What are the parameters used in each function?
Mention some important events in abap programming.
The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization
What is occurs in internal table?
Can we write the code both call transaction and session method in single program?
How do you connect to the remote server if you are working from the office for the client in remote place?
how do you transport lsmw data from one system to another?
What are two methods of modifying sap standard tables? : abap data dictionary
What is the function of the transport system and workbench organiser? : abap data dictionary
What is an Open Item in SAP? How will you find an Open Item in SAP?
when do you need to create an internal table with header line ? and with out a header line?