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 how many types of tables exist and what are they in data dictionary?
Different types of luws. What are they?
what is the t-code to link technical and functional operation?
Explain the advantages and disadvantages of abap query tool?
What is the bitwise operator in the sap abap?
What are the buffering types?
Differentiate between abap memory and sap memory?
What is the use of info groups? : sap abap hr
What is the length of function code at user-command?
Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?
What is Group by in Select statement?
What is the difference between native sql & open sql? : abap data dictionary
What is the difference between call transaction and session method? : abap bdc
What is the significance of delivery class? : abap data dictionary
send coding to write a program to create customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA2/BAPI_QUOTATION_CREATEFR OMDATA'