Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is the difference between [select single xxx from ...]
and [select * from ... up to one row]?

Answer Posted / harsha

upto one row is faster than select * from
select single xxx from xxx into wa xx = xxx-xx means it will check all the fields and finally gives a first possible record in the selected group of record
select * from xxx in wa where xx-xxx upto one row means it retrieves only first possible record of table satisfying th condition.
please revert me if any issues with this answer. i dunno weather its ryt r rong.

Is This Answer Correct ?    2 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the uses of the simple maintenance interface? : sap abap hr

1072


Explain what is the difference between primary key and unique key?

1135


what is call back in alv?

2477


How to maintain lists?

1075


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/

2325


Do you know any other patterns if yes.. explain

1310


how can you display data say "your name"in sap script without print program or driver program??

2212


what is the t-code to link technical and functional operation?

2435


What is difference between dependent and independent data?

1013


Suppose the client wants me the vacancy to be displayed on a website as well as ess. How should I do it? : sap abap hr

979


How do you document ABAP programs? Do you use program documentation menu option?

1163


what is friend class

1403


What is the difference between Classic badi and Kernal badi ?

2551


Is it possible to pass data to and from include programs explicitly? : abap modularization

1293


What are the sequences of event block?

1095