please clear this what is the diff b/w select single * and
select up to 1 row?

Answer Posted / malli.gontla

select * from means, it completely retrieves all the data
from database table. it is not good for programming.

select up to 1 row means, it retrieves all the related
values for that query.From that result first row is selected.

Is This Answer Correct ?    0 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain different types of attributes of function module?

550


What is lock mechanism? How do we create lock objects in abap?

641


Can we define our own match code id's for sap matchcodes ?

594


What is a multiple line field?

598


Is it possible to pass data to and from include programs explicitly? : abap modularization

749






What are the types of subroutines? : abap modularization

593


What does an exec sql statement do in abap? What is the disadvantage of using it?

690


How do you set up background jobs in sap? What are the steps? What are the event driven batch jobs?

570


Differentiate between abap memory and sap memory?

645


What are screen painter? Menu painter? Gui status?

604


What is narrow casting and wide casting?

1139


What are the personnel administration related infotypes? : abap hr

610


What are the differences between macro and subroutine?

620


What type of user exits have you written ?

1513


Abstract class and interface, multiple inheritance, live example

899