SELECTECT

[Former Member]

what is the diff b/w SELECT * AND SELECT SINGLE * while retrieving the data from data base?

[Former Member]

Hi

To get information on keywords, just goto abapdocu and search for keyword 'SELECT'. You will all the information.

Select is used for fetching data from the database table.

Select single will select only one record for the given conditions. If all key fields are not given in the where condition, then more than 1 record may be present in the database. But the addition SINGLE will select only 1 entry.

Regards

Navneet

PS: Reward points for all useful answers

[Former Member]

Hi,

Check this link

http://www.sap-img.com/abap/difference-between-select-single-and-select-upto-one-rows.htm

Thanks

Naren