topic Re: select from database table in Application Development and Automation Discussions

select from database table

Former Member — Fri, 20 Jun 2008 10:34:18 GMT

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 — Fri, 20 Jun 2008 10:35:48 GMT

Hi,

In the select query write:

select distinct ( filename) from dtab.

Former Member — Fri, 20 Jun 2008 10:37:08 GMT

Select DISTINCT <Col_filename> from table

into table it_tab