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 is erp? : sap abap hr

1044


In the `select' statement what is group by ?

1923


What is the use of message command in a report? What are the different message types?

905


Explain buffering

1282


dear friends, do you know how to configure web dynpro and adobe into ECC6.0 IDES?

2906


What is meant by hotspots?

1112


Did you create primary index?

1037


What is the length of function code at user-command?

1246


Use SET PF_STATUS which is in the FM reuse_alv_grid_display to set the button

2209


How to write a bdc – how do you go about it?

1105


What are the steps in a bdc session? : abap bdc

958


Can we include customizing include or an append structure with pooled or cluster tables? : abap data dictionary

1258


What are roles and authorization objects?

1625


what is the difference between Blocked ALV and interactive ALV?

2315


Which infotype records can not be deleted ? : abap hr

1038