What is the difference between select single and select upto
Answers were Sorted based on User's Feedback
Answer / manu gowdru
select single:it selects the first record which matches the condition defined in WHERE clause.so if there many records which matches the criteria will be ignored,so its not unique
select upto 1 rows:it retrieves all the records which matches the condition mentioned in WHERE clause and puts aggregate,average and gives the result
|Is This Answer Correct ?||4 Yes||2 No|
Answer / sumit0312
select single fetch the specified and matching data from the
table. and select up to 1 record directly select the first
record from the tabe.
|Is This Answer Correct ?||3 Yes||3 No|
Answer / nigesh
Select Single * will pickup only one matching record from
the database into the buffer, and returns the same to the
Select upto 1 rows will pickup all the records matching the
condition into the buffer, but return the top record to the
|Is This Answer Correct ?||3 Yes||4 No|
Answer / gagan
in select single , if multiple records are present matching
the where clause ( if stated ), then it returns the last
record among them.
While in select upto 1 rows , it returns the first
occurrence of the record.
|Is This Answer Correct ?||4 Yes||10 No|
Name the function module used to convert logical file names to physical file names in abap/4 programs?
when we are using at new?should we use this inside the loop or outside?what will be the effect?
What is the difference between ECC versions and older versions?
Explain what is sequence of event triggered in report?
what all we can see in TMG? what is its use?
How we can assign the value of field in select-options to the text-field in dialog module?
How to pass the variables to forms?
Define alv programming in abap?
Can we include customizing include or an append structure with pooled or cluster tables?
How can a lock object be called in the transaction?
what is the difference between functional spec and technical spec
How would you define the exponents for a type ‘f’ field?