What is the difference between select single and select upto
1 rows?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sumit0312
select single fetch the specified and matching data from the
table. and select up to 1 record directly select the first
record from the tabe.
Is This Answer Correct ? | 3 Yes | 3 No |
Answer / nigesh
Select Single * will pickup only one matching record from
the database into the buffer, and returns the same to the
internal table.
Select upto 1 rows will pickup all the records matching the
condition into the buffer, but return the top record to the
internal table.
Is This Answer Correct ? | 3 Yes | 4 No |
Answer / gagan
in select single , if multiple records are present matching
the where clause ( if stated ), then it returns the last
record among them.
While in select upto 1 rows , it returns the first
occurrence of the record.
Is This Answer Correct ? | 4 Yes | 10 No |
What is new enhancement framework?
what is the use of field symbol?
how to use table control?if suppose i have 6 records and i want more 4 records in sequence.How to handle this scenario?
What are the various types of the Internal tables used?
Do you know how to manage the sequence of passes in a Form?
How do you work with semi colon se[arated files in BDC ?
what is 'F4' functionality?
Have you printed any report?
Why we do Version comparison?
What is help view?
Differentiate between static and dynamic step loops?
What is step-loop?