Interested to Buy Any Domain ? << Click Here >> for more details...
What is the diffrence between select single * and Select
upto 1 row?
- 6 Answers
- 21963 Views
- Yash Technologies, I also Faced
- E-Mail Answers
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
Explain the difference between float and packed data type?
What are the basic functions of database utility? : abap data dictionary
what are the various types of parameters and how are they distinguished from one another?
To find the date difference & excude saturday & sunday in between them
In Smartforms or ADOBE Forms Can we get text from standard table in verticle form? if yes, How?
How do you find number of records present in internal table?
What are the functional areas, user groups? How does abap query work in relation to these?
What work you have done in HR module
What is a view in sap? : abap data dictionary
What is synchronous update?
What do you mean by batch data communications programming?
What is an update task?
any one can tell me which is the tables can store in ddic plese dont say db02l,please give me different ways of resideing the tables ?
What are different abap/4 editors?
What is your current client number?
