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 diffrence between select single * and Select
upto 1 row?

Answer Posted / chittidi

select single f1 f2 f3 ... into <wa> from <dbtab> where
<condition>. this where condition is important to fetch
exact record from database . for thsi purpose we provide
entire primary key combination in whrere conditon.
by using this statement to read exact information .

select f1 f2 f3 .... into <wa> from <dbtab> up to 1 rows
where <condition>
endselect.
it reads the first record found which may not be exact .
the where condition can be part of primary key combination.
it is mainly used to validate the INPUT.

IF WE ARE NOT PASSING ENTIRE COMBINATION OF PRIMARY KEY
IN SELET * SINGLE IT SIMPLY ACTS AS SELECT * UP TO 1 ROWS.

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the different types of mode (run code) in call transaction method?

1099


What is protect & endprotect?

1020


Explain what is sap script? What is the purpose of sap script? Difference between sap script and report?

1080


What are authorization objects and what statement is used to perform an authorization check in an abap program?

1009


How to determine the attributes of an internal table?

1154


What is the purpose of sum statement?

1005


What is your approach to find exit and BAdi?

1310


How will u handle the situation – In a report using function module to generate a IDOC, How will u handle the error IDOC in the same report ?

2209


Program lines for the radio button selection and unabling some input variables in section screen

1427


What is the tcode for sapscript forms?

1144


What is the definition of modification in an sap system and how do they impact an upgrade?

1124


Explain what are the events in screen programming?

1030


How do you find out whether a file exits on the presentation server?

1004


How you attach search help to data element? : sap abap data dictionary

1132


Have you set up a back ground job ? How to create a background job without a variant ?

1054