What is the difference between select single and select upto
1 rows?
Answer Posted / 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 |
Post New Answer View All Answers
Explain what is step-loop?
What are the steps in a bdc session? : abap bdc
What is value table?
How to display if the value entered contains records or not?
What is the use of message command in a report? What are the different message types?
Where the payroll results are stored
Explain the structure of a bdc sessions?
What is the disadvantage of using exec sql statement in abap?
In order to upload purchase order details, how you handle multiple values for a single field?
What are the two methods for modifying sap standard tables?
What are the aggregate objects in the data dictionary? : abap data dictionary
What is the use of start-of-selection.,if not use in report what will happen,?
ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul
Hello All, Requesting to all user of this site. Please post your Questions in Proper sub Category of chosen category. Some users post the questions in common category whether sub category for that is available ..like some users still post the SAP Script & ALE Related questions in common ABAP Category. Due to this it becomes very difficult to find the topic wise Questions. Please cooperate with the site & to other users. Thanks & Regards Tamseel
What is a data dictionary? : sap abap data dictionary