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 events used for logical database?

1080


How can you manipulate the presentation and attributes of interactive lists?

1171


How many default tab strips are there? How to insert more tabs in it?

1130


What are field groups?

1045


What is alv programming in abap?

1144


What are the steps in creating screen ?

2060


How do you work with semi colon se[arated files in BDC ?

1953


What is alv programming in abap? When is this grid used in abap? : abap hr

1166


Define database layer? : abap data dictionary

1086


What are the screen painter and menu painter?

1021


Do we have to migrate all sapscript forms to smart forms?

1084


What is a logical database?

1217


Mention what is alv programming in abap?

1209


what is difference between user exit, customer exit and badi?

5215


Explain what are the different functions used in sap script?

1058