select from database table

[Former Member]

Hi Experts,

I have a database table having fields

entity account period category value filename

A 1 001 ABC 100 abc.xls

A 1 002 ABC 200 abc.xls

B 2 001 DEF 300 sef.xls

I now need to update a control table from the database table which will select all the distinct filenames , from the database table .

how to do this

Thanks

Ankit

[Former Member]

Hi Experts,

I have a database table having fields

entity account period category value filename

A 1 001 ABC 100 abc.xls

A 1 002 ABC 200 abc.xls

B 2 001 DEF 300 sef.xls

I now need to update a control table from the database table which will select all the distinct filenames , from the database table .

how to do this

Thanks

Ankit

[Former Member]

Hi,

In the select query write:

select distinct ( filename) from dtab.

[Former Member]

Hi

Select DISTINCT <Col_filename> from table

into table it_tab