Interested to Buy Any Domain ? << Click Here >> for more details...
Wat is the difference between Select single * and Select ..
Up to one row . And which method is better for performance ?
- 9 Answers
- 26099 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / arjun manglekar
1)SELECT single retrives only one record which ever come
across first in data base query
SELECT ..upto 1 row , all records are fetched into a buffer
which are satisfied from Where condition in Data base
query , and from buffer first record is fetched .
>>same as Answer 2
2) If you know all the primary keys in WHERE condition ,
use SELECT single.
If you dont know all primary kyes in WHERE condition , use
SELECT...UPTO
3)Performance:
SELECT UP TO...is gives better performace than select single
| Is This Answer Correct ? | 11 Yes | 1 No |
Post New Answer View All Answers
What is the difference between sum and collect?
Explain the advantages of logical databases?
WHY CLUSTER TABLE CALLED AS CLUSTER TABLE.
what is field string ? & where we are using field strings?
Explain the difference between cluster tables and pool table?
What are the requirements a dialog program must fulfill?
Is it possible to pass data to and from include programs explicitly? : abap modularization
What is a table pool? : abap data dictionary
What are the basic objects of the data dictionary?
Describe the data classes?
What statement will be found in an sap application program that implements a function module exit?
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.
I need some information regarding Vcentric Test pattern ? with questions.
stock transfer from one plant to another plant ? i want the total description.
List the various components of the enterprise structure in systems, applications, and products (sap) in human capital management (him)? : sap abap hr
