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
What are the function modules used to create batch input session? : abap bdc
Why cant we use Normal function module for data transfer?
What are the functions of lock objects?
Can a filed occur in several field groups? : abap modularization
What are the rules to create a BAPI?
What is roles and responsibilities of sap hr consultants? : sap abap hr
What are the two statements which are required in an abap program to output an icon using a write statement?
What are the difference between tables and structures? : abap data dictionary
What is database utility? : abap data dictionary
What is the company code? : sap abap hr
Which database object is used for storing the system variables? : abap data dictionary
What is the use of message command in a report? What are the different message types?
Explain what is the difference between primary key and unique key?
What is synchronous update?
What are logical databases? What are the advantages of logical databases?