Skip to Content
Former Member
Feb 19, 2008 at 05:00 PM

using aggregate function count


hi experts,

I want to select 2 fields from a table and put into structure (gw_konzs.) and with respect to that i want to use aggregate function count(*) for knowing how many rows has been selected ? and i dont want to use select & endselect

please help regarding this ...........

for example:

select konts ltext from ztab into corresponding fields of gw_konzs.

select count(*) from kna1 into gw_konzs

where konzs = gw_konzs-konzs.

append gw_konzs to gt_konzs