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 the company code? : sap abap hr
What is the typical structure of an ABAP program?
hi friends i am having one doubt. if i have main window in secondpage also in smart form wether it will trigger are not?
Write the bdc table structure? : abap bdc
How to find user exit
where u can find user exists? how to activate user exists?
Can we store Data in Cluster table?
What is collective search help? : sap abap data dictionary
what is project system Landscape?
6 Answers ITC Infotech, MSG Global, TCS,
Between select .........endselect write one statement executes the cursor goes to dump analysis?what is the statement ?
why are we using events in reports than control break statements?
what are the tools in lsmw?