sql statement

[Former Member]

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]

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