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
hi frends this is bala raju from pune.i want to know diff between 4.7ee and ecc 5.0.if possible give me brief explanation.this question was asked in EDS(tele interview) in pune bye.
What is PS structure
Lock objects and what are parameters of ENQUEUE FM?
How can we determine a vendor is Bloc/Unblock from the table LFA1?
Have you printed any report?
What is a report?
What is primary index?
Name the function module used to convert logical file names to physical file names in abap/4 programs?
How many types of views are there? : abap data dictionary
What are the functional modules used in sequence in bdc? : abap bdc
What are the differences between interactive and drill down reports?
Where the payroll results are stored
What are the user interfaces of interactive lists?
How do you find if a logical database exists for your program requrements?
What is sql trace? : abap data dictionary