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


Please Help Members By Posting Answers For Below Questions

What are the 3 types of function modules in sap?

614


What is sap abap tables?

629


What are the types of subroutines? : abap data dictionary

590


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

595


What are the different types of laws. What are they?

600






What are the types of views? : sap abap data dictionary

644


Give Some examples of reports generated in real time scenarion? Also give examples of standard reports in SAP used in real time?

2326


What are the different modes of processing batch input sessions? : abap bdc

659


Structures can contain data only during the runtime of a program (t/f) : abap data dictionary

773


Explain the disadvantages of abap query tool?

577


out bound process code for quotation?

1570


Why is pretty printer user in abap?

640


Can we specify the next screen number with a variable?

565


What is your approach to find exit and BAdi?

871


How to write a bdc – how do you go about it?

666