please clear this what is the diff b/w select single * and
select up to 1 row?
Answers were Sorted based on User's Feedback
Answer / ganesh
Using Select single * we can get exact record as we are using
primary key there,where as in Select up to 1 row,it will pick
first record from the selected records.if we forgot to opt for
primary keys in the where condition in select single then
it'll act like select single up to 1 row.
Is This Answer Correct ? | 6 Yes | 1 No |
Answer / prasad
Select single * query will retrieve all the records from
the database table with respect to the condition specified
and finally select one single row among the retrieved.
In case of Select up to 1 row,the query starts retrieving
the database and once it gets the 1 row w.r.t its condition
it stops further retrieval.Performancewise using select
single * is not gud.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / archana
select single is faster performence in comparision with
select upto 1 row.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / g.shankar
if we have primary key as where condition we can go for
select single.select single is not a loop operation.
Is This Answer Correct ? | 0 Yes | 2 No |
Answer / malli.gontla
select * from means, it completely retrieves all the data
from database table. it is not good for programming.
select up to 1 row means, it retrieves all the related
values for that query.From that result first row is selected.
Is This Answer Correct ? | 0 Yes | 7 No |
Which objects are independent transport objects? : abap data dictionary
what is the IDOC status code?
Explain get cursor field?
when we use bdc and lsmw and bapis and ale idocs
Write the bdc table structure? : abap bdc
what is table control?
How to put page-breaks in smartforms?
Is der any any alternative Statement instead of HIDE which u can use in reports?
What is a collect statement? How is it different from append?
when you are using 2 internal table in program, you have decided to use for all entries statement to retrieve data but unfortunately there are no records in the first internal table. What will be the result? (2nd internal table contains records).
What is PAKEY structure, PSHD1 structure and what type of fields it contains
How to transfer data into line items using batch input session method? : abap bdc