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


Please Help Members By Posting Answers For Below Questions

What is the differences between structure and table in data dictionary in abap?

776


What are the tcodes for performance tuning?

1111


What is view? Explain the different types of view?

951


What is the differences between abap and ooabap. In which situation we useooabap?

1014


What are the different functions used in sap script? What are the parameters used in each function?

839


Mention some important events in abap programming.

772


The extract statements in field groups can be used before or after processing the sort statements. State true or false. : abap modularization

789


What is occurs in internal table?

819


Can we write the code both call transaction and session method in single program?

824


How do you connect to the remote server if you are working from the office for the client in remote place?

798


how do you transport lsmw data from one system to another?

864


What are two methods of modifying sap standard tables? : abap data dictionary

923


What is the function of the transport system and workbench organiser? : abap data dictionary

812


What is an Open Item in SAP? How will you find an Open Item in SAP?

825


when do you need to create an internal table with header line ? and with out a header line?

1739