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
How can I make a differentiation between dependent and independent data? : abap hr
Exception handling and how does it transfer from called method to calling method?
Can any tell me ECC 5.0, ECC 6.0 Released year? and difference between them?
A field containing currency amounts (data type curr) must be assigned to a reference table and a reference field. Explain?
How do you convert non-char field into char type fields ?
The data of a view is not physically stored, but derived from one or more tables (t/f) : abap data dictionary
What is an interactive report? What is the obvious difference of such report compared with classical type reports?
What is filter dependent BADI?
What are the advantages of abap query tool?
Setting up a BDC program where you find information from?
Explain the inside concept in select-options?
What does hide statement do?
Hi All , Would be providing online trainings for SAP ABAP , guidance with real time experience examples , guidance in profile prepartion . Any one intrested please contact on 8978890047.
What is pretty printer?
What are pooled tables?