topic sql statement in Application Development and Automation Discussions

sql statement

Former Member — Mon, 29 Oct 2007 02:08:00 GMT

hi all

i want to store the record into an internal table. What is the syntax?

example

select name from student where class = 'abc'.

i want to store all the name from the class 'abc' into a internal table. How can i do it? thankz.

Former Member — Mon, 29 Oct 2007 02:26:03 GMT

Hi Gary,

data: begin of itab occurs 0,

name type student-name,

end of itab.

select name

from student

INTO TABLE itab

where class = 'abc'.

Regards,

Atish