Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?

Answer Posted / manoj kumar

select single * its complsary to use prmary key where as
selectup to one row there is no need of key and it will get
only one record where as in select single we will get
multiple record based on selection criteria

Is This Answer Correct ?    0 Yes 12 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the advantages of logical databases?

581


​​What is the symbol to do “concatenation” operation in​​ nw​​ abap​​ 7.4​​ ?

776


Static and instance variable and method with live example. Why and when to use

933


IN SCRIPTS IF WE HAVE EMPTY SECOND LAYOUT AND IF WE HAVE MENTIONED ABOUT IT IN NEXT PAGE ATTRIBUTE THEN IN OUTPUT HOW WE GET THE SECOND PAGE OUTPUT.

1503


In the `select' statement what is group by ?

1521






What are the difference between pool tables and transparent tables?

631


What is the lock object?

606


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

664


How do you validate the selection criteria of a report? And how do you display initialvalues in a selection screen?

617


What is a help view? : abap data dictionary

670


How to convert normal function module to bapi?

1523


What are the data types of the abap/4 layer?

720


What is open sql?

580


What is the step-by-step process to create a table in data dictionary? : abap data dictionary

698


How is conversion of data types done between abap/4 & db layer? : abap data dictionary

650