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...

please clear this what is the diff b/w select single * and
select up to 1 row?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the check tables?

1144


If your project is support project ? when is your implementation has completed ?

2227


What are the functions of lock objects?

1252


What function does data dictionary perform?

1209


What is buffering in abap?

1287


Differentiate between table and template ?

1095


What are the different function modules used in sapscript?

1096


What is exception class and test class. How to use it?

1437


Why do we need to code a loop statement in both the pbo and pai events for each table in the screen?

1147


What work you have done in HR module

1428


What is bdc? : abap bdc

1073


1.If there is one receiver,then To send 10 materials at a time through BD10 tcode, How many Master Idoc create? 2.If there is one receiver,then To send 1 material at a time through BD10 tcode, how many Master Idoc generated? 3.Can I Send Multiple Messges through BD10 tcode?

2017


What are the disadvantages of using explicit enhancement?

2102


Can a transparent table exist in data dictionary but not in the data base physically? : sap abap data dictionary

1197


ALV Report that will show the details of order like order no, order date, customer, product code & description, order quantity and value along with the details of dispatch of those orders like invoice no, invoice date, invoice quantity and pending order quantity. plz mention the detail coding Tahnks, Rahul

2666