select statement

[Former Member]

Hello ,

Is it true that select single statement select single field from the database table . i want to confirm this i have read some where, that select sinlge can fetch single field from the database table.

regards

Fozia

[Former Member]

H

[Former Member]

Hi

Select single fetches one record from the data base not single field

In case of any queries you can revert back

Regards

Hitesh

[Former Member]

Hi Hitesh,

actually i am preparing for the certification. in one of the practise papers, the answers r given like that i'll type the question

select single can

1. select single record from the database table

2. " " internal ".

3. " " field " database ".

4. " " intranal ".

n the answers r given as 1, 3.

thnx

regards

Fozia

[Subhankar]

select single can

1. select single record from the database table

2. " " internal ".

3. " " field " database ".

4. " " intranal ".

Your answer is 1(select single record from the database table)

It select one record not one field

[Former Member]

it does not select the single field but the entire line or the fileds as mentioned by you....

[Former Member]

HI ,

Select single selects single row of data from database table .

If give you single * from from vbak where something .

In will select single row of into the wa with all fields of table vbak .

If specify some fields it will select those fields only.

Please reward if useful.

[Former Member]

Hi,

Select Single selects a single record from database table .

there can be any number of fields.

Best regards,

Brijesh

[Former Member]

Hi

if you use SELECT SINGLE MATNR

then it will fetch the only MATNR filed value that to single value which u give in where condition

it will search in the data base if the record found in the 1st line it self it won't go for the further selection and gives directly

SELECT SINGLE means hit the data base and get the 1st record which satisfies the where condition

[Former Member]

Hi,

you can use it to fetch a single record or single vlaue depending on the select statement you write.

SELECT SINGLE fieldname INTO l_var From DTAB WHERE fieldname EQ po_field.

This statement wil get single value,This is mainly used for validation purpose.

*SELECT SINGLE * From Dtab into Itab where fieldname EQ po_field.*

This statement wil get a single Record.

Regards,

Raj.