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 |
Suppose I am working on userexit if someone wants to work on same is it possible to work?
Urgent Openings for Professionals with 4+ yrs in SAP ABAP HR, for a Reputed CMM Level V Organization in Hyderabad
what is Delivery? In which tables delivery data will be stored?
hi i have one requirement on smart forms.i have to print customer details and order details(Based on customer number) in two windows.I want to write total code in report it self.can any one please help me? Thanks in an advance Vijay
what are the two methods of modifying sap standard tables? : abap data dictionary
In a report there is a basic list and 20 secondary lists. I have written Initialisation event and Top-OF-PAGE event in all of them. So how many times Initialisation and TOP-OF-PAGE event triggers?
What are indexes?
what is a value table?
I have 3 transactions,where the output of one transaction is input of another and output of 2nd transaction is input of 3rd transaction.i have one flat file with all data for the 3 transaction.if the 3rd transaction failed can we rollback the remaining 2 transactions or not.Is this possible in BDC,How/
What is the difference between data base objects and runtime objects?
i want to change alighnment of windows in scripts.How can i do that?
difference b/w classical report and intractive report